Export Test Results To Excel Sheet
Hi, Please help me with code, on how to export test results to excel sheet..
Forum Discussion
Rather than trying to drive Excel from TC and manage what row I'm on, etc. I write output to a CSV (Comma Separated Values) file using aqFile.WriteToTextFile(). For those unfamiliar with a CSV file, it's just a text file where cell information is separated by commas.
For example, a simple CSV will be in the format below.
R1C1,R1C2,R1C3
R2C1,R2C2,R2C3
R3C1,R3C2,R3C3
When your run is completed, you can open the CSV file in Excel and use filtering, pivot tables/charts, and other Excel features to browse your results.
For simple scenarios, I just use the TC logs. I only use the CSV when I verify values for ~800 products on our eCommerce site where a typical run will have upwards of 44,000 validations. The TC logs were just too much to go through, filter, etc. so I use this method instead.
One issue I ran into was that some of the values (sentences, etc.) that I wrote to the log contained commas which in CSV format means to end the cell. To get around this, I found a different character (the pipe, |) and wrote that as my separator instead of a comma. I then use the text import feature of Excel and specify that my values are separated with a | and everything works.
For example, a simple CSV will be in the format below.
R1C1,R1C2,R1C3
R2C1,R2C2,R2C3
R3C1,R3C2,R3C3
When your run is completed, you can open the CSV file in Excel and use filtering, pivot tables/charts, and other Excel features to browse your results.
For simple scenarios, I just use the TC logs. I only use the CSV when I verify values for ~800 products on our eCommerce site where a typical run will have upwards of 44,000 validations. The TC logs were just too much to go through, filter, etc. so I use this method instead.
One issue I ran into was that some of the values (sentences, etc.) that I wrote to the log contained commas which in CSV format means to end the cell. To get around this, I found a different character (the pipe, |) and wrote that as my separator instead of a comma. I then use the text import feature of Excel and specify that my values are separated with a | and everything works.
