Symptom:
From the Java web Report, You export to CSV . The Exported file contains special/different characters in between the text
Steps:
Causes:
Excel automatically uses the data format ANSI to open files. The server creates the CSV file with the data format UTF-8 if it uses Unicode.
Solution:
To open the CSV file, always use the Excel import wizard and specify UTF-8 or UTF-16 as the data format.
How to do this ?
1. Open a new Instance of Excel.
2. Click on Data:
3. Next Select “From Text”
4. Next Select the .CSV file from file system:
5. Select “UTF-8” as the encoding:
6. Click next and select the relevant separators:
7. Click on Finish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
43 | |
25 | |
17 | |
15 | |
11 | |
7 | |
7 | |
6 | |
6 | |
6 |