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
- 19787 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 difference b/w AOM,DOM,COM Have u ever is used ny of the models.If so why?
Is it possible to run qtp scripts in Test Director(Scripts are uploaded in Test director)???and also how to see the test results in test director???
Hi, actually I completed Btech(CS). But i Will go to admin (Facility) interview. So, If Interviewer asking like " Why You choose this field". What we say? pLZ PLZ PLZ PLZ >............................................Send me.....
How to call the userdefined functions to script? If i am stored 'add()' function in Library functions folder. i want to cal that function in my script.
what is the script to select 2 or more than 2 options from a listbox.
Whenever i'm running 3 diffrent scripts in a Test Batch Runner as a batch. its not showing any result. QTP only runs all the scripts n nothing else. B4 running the test batch i have done all the settings, But still its not working.
Can we call a parameter from an action to other action?
Hi .. i want to write the script for the combo nox list . For example if any combo box having a multipul itme. So how can i retrive each item for each iteration ? help me out .
hi everyone today is the first time i saw this website,and hi iam siraj,iam very impressed by seeing evryones response towards questions,iam a newcomer and i have got tryining in testing can anyone please send me some projects relaited to testing.i know it is very confidential but still if u send it will a great help. my mail id venku_krs@yahoo.co.in
what type of frame work used in your company?
wht type of User defined functions or Java Releated functions Do we write in VB scripting
How to connect to the Database from QTP?
10 Answers DB, Thatavarti Technologies, Xchanging,
WinRunner 
