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(_at_)lists(_dot_)mulberrytech(_dot_)com>
ge.com> cc
07.03.2006 03:18 Subject
AM [xsl] Return number of rows
Please respond to
xsl-list(_at_)lists(_dot_)mu
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
--~------------------------------------------------------------------
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>
--~--