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
- 19620 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 |
what is the Exact Meaning of Environment Variables?
diff between qtp versions from 8.5
How many type of status messages are there ..explain?
How do you capture tooltip using QTP?
How to measure transaction time through VBScript without using start and end transaction points?
I AM TRYING PORT CODE FROM WINRUNNER TO QTP AND DON'T KNOW TO HOW TO CHECK THE ERRORS. IN WINRUNNER FUNCTION RETURNS EIGHER 0 OR -1 AGAINST WHICH RESULT CAN BE MADE PASS OR FAIL BUT IN QTP I DON'T SEE FUNCTIONS RETURNING ANY VALUE. APPRECIATE IF ANYONE COULD HELP ME CONVERTING FOLLWOING WINRUNNER CODE TO QTP. set_window("Customer Service"); rc = web_obj_get_text("Summary","#2","#4",ssn,""," ",1); if (rc != E_OK) { report_msg("[GetSubscriberSummary] Could Not get subscriber SSN; rc = "&rc); myRC = rc; } else { ssn = StripBlank(ssn); if (DEBUG) report_msg ("[GetSubscriberSummary] SSN: "&ssn); }
What is the extension of the qtp local repository?
what is test data
suppose u have two send buttons(same width,height,font) on an application write a descriptive programming
i'm using QTP 8.2. A person using QTP 9.0 sends me a QTP TestScript, same when i try to open , an error comes "unexpected file format". Why?? and how to resolve the problem??
if i have 10 actions and out of 10 actions last 3 actions i renamed will my script exicute sucesfuly r not? changed actions where i can see?
WHAT IS ETL TESTING.......
WinRunner 
