Export Test Results To Excel Sheet

Hi Anil,



As long as I know, there is no 'one click' way to export the results to a excel from the log generated by Test Complete.



What you can do is a function that everytime a message is posted in TestComplete log, to write it down in an excel sheet. For example:



function LogMessage(text, excelRow, excelColumn)

{

  Log.Message(text);

  // Write to excel

  return new Array(newRow, newColumn);

}



This function should post a message to the Log, and then write it to the excel file you wish. There are some issues that you will have to solve:

1. 
   Keep the excel opened all the execution? Or open it and close it everytime? (You can execute Excel without beeing visible, so it won't bother in screen)


2. 
   You have to keep track over the rows and columns, so you won't write over the same cell all the time.


3. 
   You will need to change the script if you want to post messages, warnings, errors... Or create othe functions.


4. 
   What about pictures?

You can use the earlier links to know how to write on excel.



In my case, what I do is keep an array with everyline of text I want to write on excel (text + message type), and when I finish on a test set, I write them down in the excel file. What I do with pictures is save them in a shared folder and put a link in the excel file, so it won't grow up like a monster.



I hope it helped!