Hi rraghvani The purpose of storing this information in the Excel file is to capture the test ID, the test name, whether the test passed successfully, and the test version. This information is used to create a detailed report on the status of the executed tests.
My goal is to retrieve the test name along with its ID, and its result, and store this information in the Excel file for reporting purposes.
Champion Level 3If I have a good understanding of all the provided details, it would seem to me that you are going out of your way to log specific run data to TestComplete log, and than build a report by extracting such log data to place in Excel sheet.
To avoid clashing with the beast nature, I see that you only have two options:
1-Build report as you go
As other members pointed out, would it not be simpler for you to write to Excel directly as your run is proceeding similarly to writing to the default log?
You can modify your existing code to, as you write the message to the log also write it to Excel. At least that is how I would go about it.
2-Build report when run is completed
Have two runs back to back, you current project and another project to go thru all the previous project logs to read and build the report
