Hi, i have 5 sheets in a excel and each has different number of rows. i want to count no of rows in each sheet. pls guide me
you have to use excel object through vbscript and access the excel sheets ...
go through the below link... http://activexperts.com/activmonitor...soffice/excel/
for getting the rows in an excel you have use
well you can import the excel to the Data table and use the rowcount method.
the other way is using Excel com objects, but i suggest the above method which is easy.
when things gets harder ,the harder gets going
It depends on the methodology you use!!!! One can use ExcelObjecr or DataTable.
Winds of Change
Thanks i got the info