Export Test Results
Test results become truly useful when they are pushed out to the members of your organization. The Export ribbon allows you to create Word, Excel, VS Result File, and TFS Build Server versions of the test list results. If you have access to Team Foundation Server (TFS), you can easily 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.
- 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
- Execute a standard automated test list.
- Double click the result in the Calendar to drill down into it.
- Perform the export.
Export Performance Test List Results
- Execute a Performance Test List.
- Click the stopwatch icon in the Test Results panel:
- Perform the export.
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?
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 safely proceed.