Count number of rows in Excel without opening it.

‘Following code demonstrate how to count number of rows in Excel without opening it – using vbscipt in QTP.

Set objExcel=CreateObject(“Excel.Application”)

Set objWB=objExcel.WorkBooks.Open(“C:abc.xls”)

Set objSheet=objWB.WorkSheets(1)

msgbox objSheet.usedrange.rows.count

Set objExcel=Nothing

Unknown
March 2, 2011 at 7:12 pm

Its very helpful… Thanks buddy..!!!

Reply
Anonymous
March 3, 2013 at 5:38 pm

short n nice

Reply
vinod
October 22, 2013 at 9:51 am

good buddy

Reply