Unified Functional Testing (formerly QTP) News and Support Forum
Showing results for 
Search instead for 
Do you mean 

How to send QTP test results into the excel sheet.

Occasional Visitor

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

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

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

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

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