HI,

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();
sb.append("Name");
sb.append(",");
b.append("Age");
sb.append(",");
b.append("DOB");
sb.append(","); etc..........
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
Need to display in different columns and also should be comma separated when opened with notepad