Micro Focus QTP (UFT) Forums
How to export QTP report to excel format? - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: How to export QTP report to excel format? (/Thread-How-to-export-QTP-report-to-excel-format)



How to export QTP report to excel format? - nidhishnair - 08-24-2011

I want to export QTP results to the MS Excel format, any way to do it? Also i would like to know if we can just export the failed results to excel. QTP result viewer does have filters but when i export it to PDF or doc, it shows all results.


RE: How to export QTP report to excel format? - sshukla12 - 08-24-2011

Refer to this link:
https://www.learnqtp.com/forums/archive/index.php/thread-791.html

Regards,
Sankalp


RE: How to export QTP report to excel format? - Ankesh - 08-24-2011

use - Datatable.export "Filename.xls"

This will export the qtp result file to excel


RE: How to export QTP report to excel format? - nidhishnair - 08-24-2011

Hi,

Thanks, i did come across this code on the net, but i was unable to use it. I get a general run error while calling the write results function. Any idea why?
Also, i gave
sStatus="fail"
sFunctionality="blah"
sDescription="bloom"
Am assuming we can give any random strings for these values, right?


RE: How to export QTP report to excel format? - sshukla12 - 08-26-2011

Ya i think we can use random strings for these values...