Issue
If the Power Monitoring Expert (PME) Data Export Report is opened in Excel, and Chinese characters have been used such that they appear in the column headings, Excel will not display them correctly. This is an Excel issue, not a PME issue.
Product Line
Power Monitoring Expert
Environment
Viewing the Data Export Report in Excel if Chinese characters are used in device names or custom measurement names.
Cause
Ths problem occurs because the Data Export Report is saved in CSV format, and by default, Excel reads CSV files as non-unicode.
PME correctly exports the file as unicode (UTF-8), however if opened in Excel directly, Excel reads the file as non-unicode.
Resolution
If the Power Monitoring Expert (PME) Data Export Report is opened in Excel, and Chinese characters have been used such that they appear in the column headings, Excel will not display them correctly. This is an Excel issue, not a PME issue.
Product Line
Power Monitoring Expert
Environment
Viewing the Data Export Report in Excel if Chinese characters are used in device names or custom measurement names.
Cause
Ths problem occurs because the Data Export Report is saved in CSV format, and by default, Excel reads CSV files as non-unicode.
PME correctly exports the file as unicode (UTF-8), however if opened in Excel directly, Excel reads the file as non-unicode.
Resolution
How To Open a Unicode CSV in Excel (the right way)
When we scrape data from Non-English languages and give you a CSV file, the data may appear corrupted or unreadable (when you double click and open the file in Excel).
This issue occurs because we scrape the data as unicode text, but Excel reads CSV files in non-unicode by default.
This issue occurs because we scrape the data as unicode text, but Excel reads CSV files in non-unicode by default.
To configure Excel to use unicode on your exported CSV reports:
- Start Microsoft Excel
- In Excel, click theDatatab, and in theGet External Dataribbon/panel, clickFrom Text.
- In theImport Text Filedialog box, in the lower-right corner (to the right of theFile namebox), selectText Files (*.prn;*.txt;*.csv)as the file type, browse to the location where you exported/downloaded the CSV file, and then clickOpen(orImport).
- In theText Import Wizard - Step 1 of 3dialog box, selectDelimited, and from theFile origindrop-down list, select65001: Unicode (UTF-8)(or the appropriate language character identifier for your particular environment).
In the Preview box, make sure that your unicode text displays properly, and then clickNext. - In theText Import Wizard - Step 2 of 3dialog box, in theDelimiterssection, make sure that onlyCommais checked, and then clickFinish.
- In theImport Datadialog box, selectNew worksheet(orExisting worksheetif you have one), and then clickOK.
Released for:Schneider Electric Australia
