Interested to Buy Any Domain ? << Click Here >> for more details...
How can we check whether a particular sheet loaded (existed)
or not in Data Table.
- 7 Answers
- 19315 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 export(copy) the entire webtable from the webpage into Excelsheet? using Vb scripting
Tell me few important difference Between QTP and WinRunner?
I am executing a batchfile.In one script on one Button i have inserted a checkpoint.It is in a loop,my checkpoint is going to fail sometimes.That failed results only I have to log in a file.How it's possible...pls give the solution for this?
What type of automation frame work you are using?and why?
How the objecs properties are identified?Tell me in Hierarchical order?
HOW TO DO THE BATCH TESTING USING QTP?
why was automation used in the project?
1 Folders in VSS 2 In navigation script there are 100 script i want to run first 50 and 37th script also not needed to run how to do this 3 What is navigation script,Driver script, business script what we are loaded in this script 4 use of resource tab 5 Difference between verification and validation give real scenario example 6 file scripting object when to use it 7 what are the problems you are faced while testing web application 8 difference between expert view and keyword view 9 difference between QTP 8.2 and QTP 9.2 navigation frame work please answer these questions from real time working people as early as possible
explain keyword driven framework?
what is difference between Mandatrary proparties and Assistive proparties? Explain
How can we QTP Scripts in xml format? is there any way to do so?
What is recovery scenario in qtp?
WinRunner 
