Need to write chinese characters to csv file
The issue is i am having data from database when i am writing it to csv file and when opened 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 UTF-16LE encoding.
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
Need to display in different columns and also should be comma separated when opened with notepad