New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Beginners v
Excel used sheets

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Excel used sheets
Sathiya Offline
Member
***
Posts: 91
Threads: 19
Joined: May 2011
Reputation: 0
#1
Not Solved Smile  05-30-2011, 12:27 PM
hi
i want to get the number of sheets used in excel.
can any one please help me in this regard


Find
Reply
Palanimurugana Offline
Junior Member
**
Posts: 4
Threads: 0
Joined: May 2011
Reputation: 0
#2
Not Solved 05-30-2011, 03:29 PM
Can you loop thru all the sheet and find the usedrange.rows value for each sheet. if more than zero means u can increment the counter and get the desired from counter value
Find
Reply
rajpes Offline
Senior Member
****
Posts: 275
Threads: 4
Joined: Jul 2011
Reputation: 0
#3
Not Solved 07-06-2011, 09:48 AM
i don't know if there is a method to count no of sheets in an excel file but one trick is,
try to open a non existing sheet and get that err.Number
Then in your code use a loop to open all sheets one by one meanwhile keep incrementing a variable as no. of sheets till you get that same err.number
Find
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Compare Two ex cel sheets and highlight differences neerukonda9 17 14,030 06-03-2020, 12:04 PM
Last Post: rajrk
  Comparing two excel Sheets whose columns names vary Divya Roopa 2 8,646 03-26-2014, 07:20 PM
Last Post: Parke
  Iteration in Local sheets for UFT11.5 haithamQTP 1 3,197 02-27-2014, 09:12 AM
Last Post: supputuri
  How to give the For Loop for 3 work sheets? Uma 1 2,934 09-10-2011, 06:54 PM
Last Post: Uma
  Why we have global and local data sheets anbarasu 1 2,223 08-19-2009, 04:09 PM
Last Post: Saket

Forum Jump:


Users browsing this thread: 1 Guest(s)