Subject: Re: [xsl] Return number of rows From: jeb501@xxxxxxxxxxxxxxx Date: Wed, 8 Mar 2006 12:29:50 +0530 |
You can use the below vbscript to find out the no of rows Dim objXL Set objXL = WScript.CreateObject("Excel.Application") objXL.Visible = TRUE OBJXL.ActiveSheet.UsedRange.Select rc = OBJXL.Selection.Rows.Count Where 'rc' is the no of rows... Regards Eugene "Talapatra, Aruna \(GE Healthcare\)" To <Aruna.Talapatra@ <xsl-list@xxxxxxxxxxxxxxxxxxxxxx> ge.com> cc 07.03.2006 03:18 Subject AM [xsl] Return number of rows Please respond to xsl-list@xxxxxxxx lberrytech.com 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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] Return number of rows, Michael Kay | Thread | [xsl] New to XSLT technology need l, Manisha Gore |
Re: [xsl] copying a node, G. Ken Holman | Date | Re: [xsl] when to use 'as' attribut, tom tom |
Month |