'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
Its very helpful... Thanks buddy..!!!
ReplyDeleteshort n nice
ReplyDeletegood buddy
ReplyDeleteI've looked at 10 other forums looking for exactly this. None of the other solutions are as elegant as this one. Good work.
ReplyDeleteThese people both equally knowledgeable local college students in addition to beyond state and college students via various other places and nations and training 's best one way to create your profession. http://www.trustessaywriting.com/blog/compare-and-contrast-essay-topics for quality and on time writing services with responsible cost.
ReplyDeleteExcellent, Thank you very much
ReplyDeleteAwesome
ReplyDeleteThanks for this short yet apt code
ReplyDeleteEspecially the professors, they read so many essays. costco college app essay
ReplyDelete