Answer Posted / deeps
Hi,
DataTable.Export("file path")
DataTable.ExportSheet("filepath","DTsheet")
DTsheet:index or name of the sheet which u want to export
to excel file.
Ex:
Datatable.Exportsheet("c:\name.xls","name")
Datatable.exportsheet("c:\name.xls",1)
| Is This Answer Correct ? | 20 Yes | 11 No |
Post New Answer View All Answers
Suppose I have three hyperlinks with same properties. How to solve this and what are the ways to solve this. we can solve this by using index property but what are the other ways we have have to solve this problem. Login (href: btnlogin.aspx) Login (href: Sourcelogin.aspx) Login (href: homelogin.aspx)
What are the various types of Actions in UFT?
For which type of project the iterative model is suitable?
Excel sheet having some datas and some datas present in the application (in table). How will you compare these two datas? Write code to fetch datas from Excel sheet.
wht type of User defined functions or Java Releated functions do we write in VB scripting
I am facing an issue of object identification with the dropdown element of DHTML grid. When I tried to recognize these different dropdown objects, QTP identifies only one object for all the dropdowns. Hence, selection of different data from different dropdowns list is an issue. To overcome this problem, i have used Descriptive Programming technique by creating different object descriptions which have all the other properties same but differ only in one property i.e. ‘X’ location of the element on the screen. Hence, i have created distinct object descriptions that would allow us to select values in different dropdowns. The code is given below. But still I am unable to identify distinct dropdown objects. ‘Object Description for Dropdown Cell Status Set objCellStatus = Description.Create objCellStatus("micclass").value = "WebList" objCellStatus("name").value = "select" objCellStatus("x").value = 219 ------ ‘X’ Axis value for cell status drop down ‘Object Description for Dropdown Sub Segment Set objSubSegment = Description.Create objSubSegment("micclass").value = "WebList" objSubSegment("name").value = "select" objSubSegment("x").value = "319" ------ ‘X’ Axis value for sub segment drop down Please help... This is specific to DTML grid(Drop down object)
please give me the code for doing retesting of gmail login page using functions so the function has to give the value
Hi, I got error message as "object does not support this property or method: "Test.Actions" when i execute the following line of script on QTP 9.0 Dim qtApp, qtRep Set qtApp = CreateObject("QuickTest.Application") Set qtRep = qtApp.Test.Actions("Action1").ObjectRepositories Can anyone tell me where i am wrong.
What is the quicktest professional testing process?
What is difference between run time object and test object?
Can any one tell me about "Mapping Repository Parameter Values" and why we use it....??How to use it???Please, tell the preconditions also...........???? Thanks in Advance
Where to use function or action?
In application which areas to be automated and what kind of situation will be take? using QTP? Plz give me the clear answer
How the smart identification is used in real time?Please explain with an example
What is a Patch in QTP?