Pages

Wednesday, March 2

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
Posted by at

9 comments:

  1. Unknown2 March 2011 at 19:12

    Its very helpful... Thanks buddy..!!!

    ReplyDelete
  2. Anonymous3 March 2013 at 17:38

    short n nice

    ReplyDelete
  3. vinod22 October 2013 at 10:51

    good buddy

    ReplyDelete
  4. Anonymous1 December 2014 at 20:20

    I've looked at 10 other forums looking for exactly this. None of the other solutions are as elegant as this one. Good work.

    ReplyDelete
  5. Anonymous14 April 2015 at 14:17

    These 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.

    ReplyDelete
  6. Unknown20 May 2015 at 04:55

    Excellent, Thank you very much

    ReplyDelete
  7. Anonymous19 January 2016 at 00:15

    Awesome

    ReplyDelete
  8. Anonymous22 November 2016 at 06:55

    Thanks for this short yet apt code

    ReplyDelete
  9. Hazel Jack6 May 2020 at 23:13

    Especially the professors, they read so many essays. costco college app essay

    ReplyDelete

Subscribe to: Post Comments (Atom)