How can we check whether a particular sheet loaded (existed)
or not in Data Table.
- 7 Answers
- 17639 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can we retrieve the Bug Ids which are open&Reopen in status through QTP scrit?Please find the script which i tried... Dim objBugFactory, objBug Dim BugId Set TDConnection = QCUtil.TDConnection Set objBug = TDConnection.BugFactory If QCUtil.IsConnected then Reporter.ReportEvent 0, "Connected", "Connected to server: " + QCUtil.TDConnection.ServerName + chr (13) +"Project: " + QCUtil.TDConnection.ProjectName + chr (13) + "Domain: " + QCUtil.TDConnection.DomainName Reporter.ReportEvent 0, "Current time on server is","==>" & TDConnection.ServerTime Else Reporter.ReportEvent 1, "Not connected", "Not connected to Quality Center" End If If mybug.Status="Open" Then BugId=mybug.DefectId MsgBox BugId End If 'OR**********************************--------------------- -----********************************** If Bug_Fields("BG_STATUS").Value ="Open" Or "Re Open"Then BugId=Bug_Fields("BG_BUG_ID").Value MsgBox BugId End If
Explain how you can delete excel file in qtp?
To which environments does quicktest professional supports?
How do you test the text displayed in the header portion of times of india epaper. Hot news(banner) are scrolling in the top of the page, how do you test using QTP?
Hi Samrat, Thank u very much, what u said it is right.
What is recovery scenario manager? When you go for recovery scenario manager?
what testplan contents and what test strategy contents,what is the diff b/w them
How software automation specialist enter steps in the Expert View?
What are the different types of recording modes?
Why do you create a text checkpoint on a Web application? What is the purpose of the Close method?
Why qtp the best testing tool?
What is the parameterization?
Explain the differences between table and db checkpoints?
How to start recording using quicktest professional (qtp)?
How many types of recording modes in qtp? Describe each type with an example where we use them?
