Opening a TestStand XML Report in Microsoft Excel 2010

Updated May 3, 2018

Reported In

Software

  • TestStand 2014
  • TestStand

Issue Details

I am using TestStand's XML report format. How can I view my reports in Microsoft Excel 2010?

Solution

Note: These instructions are for Microsoft Excel 2010. If you are using Microsoft Excel 2003, then please refer to the instructions in KnowledgeBase: How to Import a TestStand XML Report into Microsoft Excel 2003 with Proper Formatting?. If you are using Microsoft Excel 2007, then please refer to the instructions in KnowledgeBase: Opening a TestStand XML Report in Excel or Word 2007

The first step is to open the XML report from within Microsoft Excel. You will be prompted to select the proper stylesheet to use as shown below.
 


Select Open the file with the following stylesheet applied. Microsoft Excel pulls the path of the stylesheet to be used from the XML document itself, so you do not have to set the file path. 

If the specific stylesheet is not present at that location on the machine that is being used, then you may either open the document in Microsoft Excel without styling or manually modify the path for the stylesheet by opening the XML document in a text editor. The value that you will need to modify in the XML document is the href attribute of the xml-stylesheet element, which should be located at the beginning of the document. Change this path value to match the file location of the XSL stylesheet on the machine.

The XML report may fail to open if the XSL security settings for Microsoft Excel are not configured to allow scripts in stylesheets. If the security is not configured properly, the following XML error will be displayed:

Description: Security settings do not allow the execution of script code within this stylesheet. 
 

In order to open a TestStand XML report in Microsoft Excel, you must make some modifications to the registry to disable this security check. 

Note: Making the following modification could make your computer or network more vulnerable to attack by malicious users or by malicious software such as viruses. The security setting preventing Microsoft Excel from opening stylesheets with scripts is designed to protect your computer from malicious scripts hidden in XSL stylesheets. Only open files from a trusted source. More information on this error can be found at this Microsoft KnowledgeBase article: Microsoft KnowledgeBase KB908556: Error message when you try to open an Excel 2007 workbook: "Scripts in this XML document are disabled"

To disable the security check, follow this procedure:
  1. Open Registry Editor. (Navigate to Start»Run. Type regedit and click OK.)
  2.  As with all registry edits, it is a good idea to make a backup before modifying the registry. To make a backup, go to File»Export in the Registry Editor.
  3.  Expand the folders to navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security.
  4. The security key should contain a value called XSLSecurityLevel. If the value does not exist, you can create it by right-clicking under the (Default) String Value entry and selecting New»DWORD (32-bit) Value. Named the new entry XSLSecurityLevel.
  5. Double-click on XSLSecurityLevel.
  6. Enter 1 in the Value Data.
  7. Click OK.

Now you should be able to open your TestStand XML report from Microsoft Excel 2010. You may see a warning message about the format of the file not matching the file extension when you open the file, but you can just click Yes to continue opening the file and ignore this warning.

To reset this setting and re-enable the security check:
    1. Go back to the Registry Editor.
    2. Navigate to HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security.
    3. Double-click on XSLSecurityLevel.
    4. Enter 0 in the Value Data.
    5. Click OK.

Additional Information

If a computer administrator has blocked access to the registry, they will need to go in and make the necessary changes. Additionally, if the computer in question can not be allowed to do scripting due to security concerns, other reporting options will need to be considered.

WAS THIS ARTICLE HELPFUL?

Not Helpful