How can we check whether a particular sheet loaded (existed)
or not in Data Table.
- 7 Answers
- 17181 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / madhulika
On Error Eesume Next
datatable.getsheet("Sheet name")
'Checking error number, if no error then returns 0
If err.count<>0 Then
msgbox "Sheet not available"
Else
msgbox "Sheet available"
End if
On error go to 0
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / nandankumar
Once we execute the test then if we check in result window
we have run time datatable there we can check out whether
our specified sheet is existed or not.
if i am wrong, please correct me..
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ravi
ONCE WE CAN USE INSERT METHOD IN DATA TABLE METHOD OFTER
EXECUTING THE STATEMENT WE WILL GO TO THE RUNTIME DATA
TABLE IN THE WHEREEVER WE INSET PLZ GO AND CHECK
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / veeresh babu
We can use datatable.getsheet("sheetname")
to access any sheet at run time
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ramana vanteru
For the above answers, i would like to add somemore info,
In datatable, after adding a sheet, we can get the sheet
count with the following script..
Ex: datatable.addsheet("New_sheet")
msgbox datatable.getsheetcount
Note: "getsheetcount" will give us the no.of sheets present
in the datatable.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / saradarao.v
hi,Ramana Vanteru
if u don't mind pls send me ur id
| Is This Answer Correct ? | 0 Yes | 3 No |
How to use debug tools?
What is the present version of the VB Script we are using
what is the abbrivation of .mtr in action reposirtory?
Consider one application is open, clicking one menu will open another application in another browser. QTP does not catch the URL of the second browser(second application). can we capture it ?
what is the hierarchy to use properties in descriptive programming
What is test object model in QTP ?
Describe the process for writing text check point for a web application?
Write a script to print below pattern 5 4 3 2 1 5 4 3 2 5 4 3 5 4 5
In QTP whether is it possible to call a function from one action to another action?
can u give one scenario for for PopWindow Exception & write Code for that?
We have 10 page.In first page we 2 popup and next page we 3 popup window......(windows name is different)how can we handle the all the popups without using recovery scenario
What is data driver in qtp?
WinRunner 
