How to send QTP test results into the excel sheet. (14674 Views)
Reply
Occasional Visitor
Posts: 2
Registered: ‎09-06-2011
Message 26 of 30 (1,097 Views)

Re: How to send QTP test results into the excel sheet.

Hi,

 

Did u get any resolution for the exporting the QTP results to excel. I'm looking to do the same....

 

Pls reply.. Thank you in advance

 

---

Swapna


Gaurav Varshne wrote:
Hi,

I have implemented the above code but it throws an error. Stating "Error in Function Library."

Could you please quote the same code again with the example.

Thanks for the same.



Occasional Visitor
Posts: 2
Registered: ‎09-06-2011
Message 27 of 30 (1,095 Views)

Re: How to send QTP test results into the excel sheet.

Hi,

 

Did u finf the solution to export the qtp result to excel. Even i'm looking for the same solution.

 

Can you plz share your findings.

 

Thank u in advance.

 

----

Swapna


Gaurav Varshne wrote:
Hi,

I have implemented the above code but it throws an error. Stating "Error in Function Library."

Could you please quote the same code again with the example.

Thanks for the same.



Occasional Visitor
Posts: 1
Registered: ‎03-07-2013
Message 28 of 30 (876 Views)

Re: How to send QTP test results into the excel sheet.

Use bit of VBScripting, VBA, and XSL, I did  the following to export the result (as it is visible in QTP Test Result Viewer) in Excel

1. Exported the Results.xml in HTML format by using custom XSL (not the useless PDetails or PShort). -- some VBScripting is needed.

2. Used the HTML as web query in Excel. - Some VBA .... actually lot of VBA as I went crazy with the report and its layout :-)

Visitor
Posts: 1
Registered: ‎12-12-2013
Message 29 of 30 (582 Views)

Re: How to send QTP test results into the excel sheet.

I need to write the code or script for the below attached scenario, Please let me know as soon as posible

Occasional Contributor
Posts: 6
Registered: ‎07-17-2013
Message 30 of 30 (360 Views)

Re: How to send QTP test results into the excel sheet.

HI,

 

Could you pls share solution ofr this -

How to send QTP test results into the excel sheet

 

Regards

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.