Export Test result to Excel sheet.

[newqtp]

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

Thanks.

[Cpt.Zack]

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

[Cpt.Zack]

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

[newqtp]

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.

[Cpt.Zack]

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


see attachement.

[newqtp]

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

[Cpt.Zack]

Good luck then

[Cpt.Zack]

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.