Export Test Results

The Export ribbon allows you to create HTML, Xml, Word, Excel, VS Result File and TFS Build Server versions of a test list results. If you have access to Team Foundation Server (TFS), you can reload results from and publish to the server using the buttons in the Scheduling Server ribbon. For more details see the Test Scheduling article series.

Results tab

  • HTML: Export run result to an HTML document.

  • Xml: Export run result to an Xml document.

  • Word: Export run result to a Microsoft Word document.

  • Excel: Export run result to a Microsoft Excel document.

  • VS Result File: Export run result to Visual Studio test result .trx file.

  • TFS Build Server: Publish the currently selected run result to the build server to be associated with a specific product build.

  • Submit Bug: Load the Submit Bug dialog and log a bug about the failed result in your previously configured bug tracking application.

Export Automated Test List Results

1.  Execute a standard automated test list.

2.  Double click the result in the Calendar to drill down into it to be able to export to Word and Excel format. HTML and Xml export is available from any level of the Calendar view.

3.  Perform the export.

Export table

Multiple Results Export

HTML and Xml export supports multiple run results export. Please note that HTML and Xml export requires there is a default program set since the exported file is automatically opened.

1.  Execute a standard automated test list few times.

2.  Select multiple test list results from the Calendar view using Shift and/or Ctrl keys.

3.  Perform the export.

Export HTML

Email Test List Results

Additionally any results within the calendar view could be emailed using the default email client configured on the host machine. To email Word and Excel exports the test results should be drilled down.

Email Word/Excel

HTML and Xml emailing supports multiple test results emailing.

Email HTML/Xml

Note: Once the email is generated the From field in Outlook email shows a default Telerik email address which needs to be changed to the configured one on the host machine.

Export Performance Test List Results

1.  Execute a Performance Test List.

2.  Click the stopwatch icon in the Test Results panel:

Stopwatch icon

3.  Click an export format from the Export ribbon to export the results.

Performance export table

Note: When opening an exported Excel result you receive the following warning:

The file you are trying to open, 'fileName.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening this file. Do you want to open the file now?

Excel warning

When Test Studio exports data to Excel format it actually exports it as an HTML structure (which Excel can successfully parse). The alert is a new security feature in Excel 2007 called Extension Hardening, which ensures that the file content being opened matches the extension type specified in the shell command that is attempting to open the file. The file must be in XLS (BIFF8) or XLSX (Open XML) file format to open without this warning prompt. If the file type is a different format (such as HTML, XML, CSV, etc.) the prompt is expected since the file content is different that the extension or MIME type.

Click Yes to proceed safely.