How can we export the "test result" to any excel sheet automatically after completion of execution of test???

  • Interview Candidate
  • 21
  • 5299

Showing Answers 1 - 21 of 21 Answers

megh1614

  • Dec 14th, 2006
 

In Expert view by adding below step  we can directly export the test results to the external excle sheet. DataTable.ExportSheet  "Destination Path for xla" ,1 (index number for the run data sheet in test results).

megh1614

 

 

 

  Was this answer useful?  Yes

Narayan

  • Dec 19th, 2006
 

Create a QTP object and in that one change defalut.xls path......that all

  Was this answer useful?  Yes

Debleena

  • Dec 28th, 2006
 

To export the "test result" in an external xls file the syntax is ------

DataTable.ExportSheet TablePath,SheetName

where, TablePath is the destination xls file path, e.g- "D:abc.xls"

SheetName  is the sheet name where the result is to be exported, eg- "MainSheet"

  Was this answer useful?  Yes

nareshjayaseelan

  • Nov 17th, 2007
 

Hi i tried this, but it will only export the data from run-time Data Table. What i want is to export the status of the execution. For example: after a execution of a simple VB script reporter.reportevent 0,"testing","India".
Qtp will give a o/p passed. now i want the test name,status & execution data to be exported to an external excel sheet.
Thanks
Naresh J

  Was this answer useful?  Yes

apchinni

  • Apr 23rd, 2008
 

Guys,
Please read the documentation atleast once before you post any answers here.
DataTable.Export statement is only useful to export the runtime datatable.  You will see the data used at run time in runtime datatble.
in QTP by default we can only export results in the format of .html file or .xml file. But you convert the .xml file into .xls using your own logic.

Thanks

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions