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



CLARiiON CX Series




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).




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.