How can we check whether a particular sheet loaded (existed)
or not in Data Table.
- 7 Answers
- 17167 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How many lines of code in each script of QTP?
Explain the concept of object repository & how qtp recognizes objects?
Hi friends did any budy attend accenture system test for qtp? if any budy pls drop questions.not only accenture any other mnc company which you attended system test(QTP)?it may helpful to others also
How to save your test using quicktest professional (qtp)?
How many types of parameters are available in quicktest professional?
Hi Guys, I want to place all of my values which i am getting it from a loop in to a global shee. For that i had written the script like this For i = 1 to ECOs-1 ECO = List(i).GetROProperty("innertext") DataTable.AddSheet("ECOList") DataTable.GetSheet("ECOList").AddParameter "ECOList",ECO AbortECO = DataTable.GetSheet("ECOList").GetParameter ("ECOList").Value msgbox AbortECO DataTable.GetSheet("ECOList").SetNextRow Using the above script, whenever the loop iterates it is creating new column "ECOLIST" in the sheet called "ECOLIST". It means, the values are displaying in the column wise even though i added the script " DataTable.GetSheet("ECOList").SetNextRow" . The cursor is not moving to the next line. Anybody help me out how to pass the values from script to the excel(Global/Local) sheet. Pls let me know @ nbabu11@gmail.com if you are not clear about the question.
Hello friends..... On which areas of an application we can not test with QTP
How to execute the WR Script through QTP? I have WinRunner script with initialization script, common scripts, GUI AND functions. I connected WR through QTP with "call to WinRunner" option but I am getting problem after connecting to WinRunner i.e. showing "Do you want to quit now" with 'yes' and 'No' message box
What is action?
what is run action?
what type of framework u r using in ur organization
X flies from Hyd to bangalore using different methods of transportation. write the test scenarios and test cases for this?
What is the difference between qtp and selenium?
Could anyone help me for the below scenario: i am using the descriptive programming for my account, in which we have to generate the contract in the MS-word. when i generate this doc, we need to click on enable macros to continue further. but i am unable to make qtp to click on this. if anybody faced the problem like this??? pls help to get it resolved? Thanks in advance
Give me some real time point of way where exactly we can conduct audits?
