I am using Super CSV for creating CSV file. When I write special characters like umlaut characters ï
or î
then it breaks in the generated CSV when I open it using Excel. When I open the same file using Notepad++ it shows the umlaut characters perfectly.
Any idea what could be the cause? I have specified UTF-8 encoding. Is there something that I am missing?
ICsvListWriter writer = new CsvListWriter(
getWriter(getCUSTOMEREXPORT_FOLDERPATH()+filename),
CsvPreference.STANDARD_PREFERENCE);
private static OutputStreamWriter getWriter(String fileName) {
final File file = new File(fileName);
return new OutputStreamWriter(new FileOutputStream(file),
Charset.forName("UTF-8"));
}