How to import the XML file generated with Report Wizard into Microsoft Excel

Product:

 

CLARiiON CX Series

 

Description:

 

Unable to import the XML report into Microsoft Excel

Copying from the XML file and pasting to Excel works fine for US localized Excel, but not for non-US localized

Microsoft Excel (for example, regional settings, standards and format and location set to Germany or German

Microsoft Excel).

 

Solution:

 

If the copy and paste option does not work on your workstation setup, use following steps to import the report:

1.     Generate the report that you want to import.

2.     In Excel click File, Open, and select the correct Report xxx.xml file.

3.     On the "Import XML pup-up window ("The file you are opening contains style sheet[s]. What would you like to do?"), select the second option ("Open the file with the following style sheet applied [select one]:").

4.     Leave #style sheet in the drop-down window as the default and click OK.

Also refer to Knowledgebase solution ID 13374 for more information on the issue.