How can we check whether a particular sheet loaded (existed)
or not in Data Table.
- 7 Answers
- 17633 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 Property......End Property loop? how to write sript for it in QTP
Pls let me know completely about descriptive programming, where it is used, pls explain with a real time example of its occurence and the program code written in qtp.
WHAT IS DIFFERENCE B/W QC 9.2 AND QC 10.0
how to automate standalone infopath forms using QTP? (it is not a dotnet or a web form)
I am Using QTP 9.1 version. I have created a Shared Object Repository. The size of Shared Object REpository is 9 MB. In my system i am able to execute the script very flexibly and it is very fast. But if i copy the same code into other system with the same configuration, it is executing very slowly(i.e dam slow). It is not happening in all machines it is in only some machines. Can please any one give th esolution. It is high priority to me as i need to give demo to client on their machines.
QTP is used better in which type of application Web based application or desktop application
is the institute MindQ laid by Mr.Nageswar rao.. heard alot about Nageswar rao...can you briefly let me know about the Nageswar rao inst. and MinQ...THANX IN ADVANCE
What is the vb script when the url enter into the browser
Hi, Plz give best Definition of Software Testing? Why we need Software Testing? and plz send 2+yrs experience Interview qutions (Manual,Qtp).
How can the name of a checkpoint be changed in Qtp
We are calling Actions in Expert View by using Run Action.but i want to know where we are saving the Actions Scripts.Pls explain??
How to Open FireFox using descriptive programing? If my question is not clear, i will give an Example To Open Internet Explorer, We use Set IE = CreateObject(InternetExplorer.Application) IE.Navigate "www.yahoo.com In the same i need to open yahoo.com in firefox. Can any one tell me what is the server name of firefox to create an object
WinRunner 
