I don't remember the exact details of the excel export format but it's
something like

<ss:row> 
 <ss:col>
   <ss:data>

and a row is "populated" if at least one column contains an ss:data element.

So your expression is count(//ss:row[ss:col/ss:data])

Michael Kay
http://www.saxonica.com/


> -----Original Message-----
> From: Talapatra, Aruna (GE Healthcare) 
> [mailto:Aruna.Talapatra@xxxxxx] 
> Sent: 06 March 2006 21:49
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject:  Return number of rows
> 
> 
> Hello:
> 
> I am processing an excel sheet which contains 5 columns..
> 
> There may be any number of rows in this excel.
> 
> I am trying to figure out how I can get the number of rows that are
> populated in this excel sheet.
> 
> Can someone please help me out.
> 
> Eg.
> 
> Index LastName FirstName DOB
> 
> 1 Test1 Name1 XXX
> 
> 2 Test2 Name2 XXX
> 
> 3 Test3 Name3 XXX
> 
> 4 Test4 Name4 XXX
> 
> Number of rows should return 4.
> 
> Thanks in advance!
> 
> Aruna