Chinese characters in Excel
Were u able to resolve this issue ,
I am also facing the same issue i am having data from database when i am writing it to csv file and open it in excel all values are coming in in a single column whereas rows are coming up , like i am having 4 column and two rows(one header and one value) , now i am getting one column and two rows.
I am using same as above code except not ExcelCSVPrinter and using UTF-16LE
and also changing BOM to little Endian
i am appending values to StringBuffer and then appending values to that.
encoding is UTF-16LE
StringBuffer sb = new StringBuffer();
byte bytes = sb.toString().getBytes(encoding);
bytes = (byte)255;
bytes = (byte)254;
the above code diaplays chinese but columns are not coming , its all in a single column