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(_dot_)Talapatra(_at_)ge(_dot_)com]
Sent: 06 March 2006 21:49
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: [xsl] 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
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--