Chinese characters in Excel

**Jayashreevmenon** · 08-04-2011, 08:29 AM

Hi Thendral,

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();
sb.append("abcd");
sb.append(","); ........
byte[] bytes = sb.toString().getBytes(encoding);
bytes[0] = (byte)255;
bytes[1] = (byte)254;
fileOut.write(bytes);
fileOut.flush();
fileOut.close();
the above code diaplays chinese but columns are not coming , its all in a single column

**DarrylBurke** · 08-04-2011, 08:52 AM

Jayashreevmenon, welcome to the forum. In future, please don't post to threads which are long dead, and don't hijack another poster's thread. When you have a question, start your own thread. Feel free to post a link to a related thread.

As your post shows very clearly (... except ... also changing ... columns are not coming), your problem isn't even the same as Thendral's.

db