How to import the Test Results in QTP to an Excel sheet

Answers were Sorted based on User's Feedback



How to import the Test Results in QTP to an Excel sheet..

Answer / mahi

if we want import complete sheet then go for


Datatable.Export "path of the excel file"

if we want import a perticular sheet then go for,

Datatable.ExportSheet "path of the excell file",SheetId to be exported

Is This Answer Correct ?    1 Yes 0 No

How to import the Test Results in QTP to an Excel sheet..

Answer / sudeepthz

could you explain with an example.. that would be greatful to me

Is This Answer Correct ?    0 Yes 2 No

How to import the Test Results in QTP to an Excel sheet..

Answer / venkat reddy

we can import testresults to excel sheet by using datatable
methods

Ex:-datatable.exportsheet "path where you want to
save.xls",sheetid


if i am wrong please correct me...

Is This Answer Correct ?    0 Yes 3 No

How to import the Test Results in QTP to an Excel sheet..

Answer / ravindra

DataTable.ExportSheet Relativepath &"path of that
excelsheet","Sheetname"

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More QTP Interview Questions

It seems Interview questions from Ordain Solutions are almost BASIC LEVEL-Easy. I am asking one tough question..(I think.. May be easy for some people) In recorded script the - WebLink("cityinfo") In reality, the WebLink name is "generalinfo" How you can write function to click that changed web link. NOTE: This functin should work with any Dynamic text link. I will post the answer later.

8 Answers  


What is keyword view?

0 Answers  


How can we add regular expression for date field (dd/mon/yyyy)?

3 Answers   CTS,


object types is used for what?

1 Answers  


Definationions for keyword view and tree view?

1 Answers  


What are the different recording modes and how do they work?

0 Answers  


what is the extension of action script template?

7 Answers   Capco,


What is the parameterization? Give one example?

0 Answers  


what is the difference between call to copy action and call to an existing action

5 Answers  


How to make arguments optional in a function?

6 Answers   Liquid Crystal,


How to see entire results at the same timeafter the batch run.. Cannot see the entire results at a time. Is there a easier way view everthing at same,as our batch file very large

2 Answers  


WHAT IS OBJECT REPROSITORY?

4 Answers   BirlaSoft,


Categories