[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Return number of rows
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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|