I am running a test, and am using Reporter.reportEvent. Is there a way that I can export the result to excel sheet. Here is my scenario: I am using LocalSystemMonitor to get results of some counters, and am using Reporter.reportEvent to display the result in the Result page. I need to find a way where I can export the Details which contains the counter result to a file whether an excel file or a notepad.
You want to export the messages from your Reporter statements?
The reporter writes custom report messages to the result file.
If you want them in an excel file, the easiest way would be write the same into the datatable and then export the file.
Now since you are using systemmonitors, I guess an excel file with data will already be availble to you, so if you wish write data in the same file, you can look at using Excel objects and write to the same file based on your counter values.
In Expert view by adding below step we can directly export the test results to the external excle sheet. DataTable.ExportSheet Destination Path for xla 1 (index number for the run data sheet in test results).