How can we check whether a particular sheet loaded (existed) or not in Data Ta

Categories >> Software >> Testing >> Automation Testing >> QTP
Suggest New Category

How can we check whether a particular sheet loaded (existed)
or not in Data Table.

Question Posted / gvnsuresh

7 Answers
19512 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can we check whether a particular sheet loaded (existed) or not in Data Table. ..

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

How can we check whether a particular sheet loaded (existed) or not in Data Table. ..

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

How can we check whether a particular sheet loaded (existed) or not in Data Table. ..

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

How can we check whether a particular sheet loaded (existed) or not in Data Table. ..

Answer / veeresh babu

We can use datatable.getsheet("sheetname")
to access any sheet at run time

Is This Answer Correct ?

0 Yes

0 No

How can we check whether a particular sheet loaded (existed) or not in Data Table. ..

Answer / vaani tks

U can debug and watch the data table at run time, so that
we can see that particular sheet is loaded or not.. or u
can use wait statement to view it..

Is This Answer Correct ?

1 Yes

3 No

How can we check whether a particular sheet loaded (existed) or not in Data Table. ..

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

How can we check whether a particular sheet loaded (existed) or not in Data Table. ..

Answer / saradarao.v

hi,Ramana Vanteru
if u don't mind pls send me ur id

Is This Answer Correct ?

0 Yes

3 No

Post New Answer