Count number of tabs in Excel with UFT
| ♥ 0 |
I’m using UFT to compare to Excel workbooks. I need to count the number of tabs in each worksheet. Using ‘excelObj.WorkbookName.Sheets.Count’ is returning more tabs than the number of tabs that are there. Is it counting deleted tabs or something?
Marked as spam
|
Posted by |
Private answer
It's probably seeing hidden tabs that exist in the workbook. Here's a sample of some code that you can use that will count the number of visible and hidden tabs so you can see a count of each. You can take the code a step further and use the visible count variable in your script for the value of the number of visible tabs displayed and this should return the correct number you want: For i = 1 To excelObj.WorkbookName.Sheets.Count MsgBox ''Visible Tabs Count: ''& visibleCount & '' Invisible Tabs Count: ''& invisibleCount Marked as spam
 Posted by rich-text (Questions: 2, Answers: 477) Answered on July 18, 2017 5:17 pm
|