Micro Focus QTP (UFT) Forums
Export Test result to Excel sheet. - 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: Export Test result to Excel sheet. (/Thread-Export-Test-result-to-Excel-sheet)



Export Test result to Excel sheet. - newqtp - 03-20-2008

Hi ,
How can i export my test result summary to excel sheet??

Thanks.


RE: Export Test result to Excel sheet. - Cpt.Zack - 03-21-2008

Export to HTML file and then save it as a .xls file.


RE: Export Test result to Excel sheet. - Cpt.Zack - 03-21-2008

BTW, I checked it works, Also,Try to automate the process of conversion from Html to excel --. I have done this before using VB, so iguess you should be able to


RE: Export Test result to Excel sheet. - newqtp - 03-21-2008

Hi Cpt.Zack,
As for your suggestion i've tried that..But there is no such option for saving file as xls, I'm attaching file. you can have look.


RE: Export Test result to Excel sheet. - Cpt.Zack - 03-22-2008

First Export to html file
open html file
Now save as .xls


see attachement.


RE: Export Test result to Excel sheet. - newqtp - 03-24-2008

Hi Cpt.Zack,
Thanks for quick response..it worked.
Thanks.


RE: Export Test result to Excel sheet. - Cpt.Zack - 03-24-2008

Good luck then Smile


RE: Export Test result to Excel sheet. - Cpt.Zack - 03-24-2008

Btw, Write a code in VB to automate the process of converting .html to .xls, Its fairly simple! Then include this code inyour script to autogenerate the results in .xls and place it in a folder.