How to export QTP report to excel format?

[nidhishnair]

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.

[sshukla12]

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

Regards,
Sankalp

[Ankesh]

use - Datatable.export "Filename.xls"

This will export the qtp result file to excel

[nidhishnair]

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?

[sshukla12]

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