Results to Excel Sheet

[bfakruddin]

Hello...

How to send Results in to the Excel Sheet by scripting?

"I have to send all the results in result window to Excel Sheet"

[somisays]

Dearbfakruddin,
Do you mean external excel sheet ?
or Runtime Datatable ?

[bfakruddin]

After running the Test Script, we will get the results in result pane rite...
that results to the excel sheet (.xls) to our desired path.

[somisays]

Hi,
Use DataTable.Export or DataTable.ExportSheet accordingly.

[sreekanth chilam]

Hi Somi,

I hope you haven't got the given question clearly.

The Question is not regarding the Design Time/Run time datatable at all.

Is there any way of exporting Results from Test Results window --> Excel file ?
As we have "Export to HTML" option in Test results screen, simillarly do we have "Export to Excel" option in Test results screen.... ? This is exact Question FYI.....

[newqtp]

We can export the result in HTML format by using "Export to HTML" option in test result screen, after exporting your result in HTML format goto the location where this file is exported or stored, open this HTML file and save it as .xls file. Now you have your test result in Excel format.

[sreekanth chilam]

Hi NewQTP,

As per your above answer, Are you sure that we can save As HTML file into .xls file?

FYI..... Save As ".xls" option is not available for HTML file.

@ ALL : Please provide accurate answers ....as everybody are spending their valuable time inorder to view this blog.

[bfakruddin]

Thanks for your answers.....!

we have one option in results window.... after running your script open your result pane and right click on results pane... There you can find export results to excel sheet....
I hope this is correct way... but it is not working properly... it is exporting to excel sheet but it is showing some warning message and not exporting to excel sheet...

please check it once in your QTP and answer....

one more thing... I have not asked the way results exporting to excel sheet... I asked the script...!

Why am I getting warning here?
What is the script to export results to excel sheet?
What is the manual way? provide full navigation...

thanks & regards
Baba Fakruddin.D

[sreekanth chilam]

HI ,

Infact this questions comes under "Customization of test results"

As per my knowledge , you can go for following:
1) Write a user defined function for posting required results into Excel/Txt files.
2) Setting up the Logger folder in Registry editor, inorder to get the results in HTML & wil be stored in current test's 'res' folder automatically after the Test Run.

I hope there is no way for customizing the "Test Results" window/screen itself.

@Ankur : If possible , Can u put some light on to this query.

[bfakruddin]

Hello,

it is okay.... My question here is the option available in resuls pane...

Right Click --> Send results to Excel Sheet...?

What about this?

thanks & regards,
Baba Fakruddin.D