How to export the chinese character to excel using ExcelCSVPrinter. Open the file within browser

[Thendral java]

Hi,

Our application using in English, German, Franch and chinese.
String chineseCharacter=""; // chineseCharacter like 長长牀床東东彿佛. This chinese data coming from oracle database..
when i using,
responses.setContentType("text/html; charset=UTF-8");
It works fine for German , French and Chinese. (So There is no issue in Stream and Retrieval from database)

But when i using the following only i get junk values like 長长牀床東东彿佛. We using the windows Xp browser is IE , mozila and safari. Service pack 3

My code

--------------------------------------------------------------------------------

BufferedWriter printer = new BufferedWriter(new OutputStreamWriter(responses.getOutputStream(),"utf-8"));
responses.setContentType("application/download");
responses.setHeader("Cache-Control", "cache");
responses.setHeader("pragma", "cache");

ExcelCSVPrinter outcr = new ExcelCSVPrinter(printer);

String displayname="ChineseReport.csv";
responses.setHeader("Content-Disposition","inline; filename=\"" displayname "\"");
outcr.write("Report Header Name");
outcr.writeln();
outcr.write(chineseCharacter);
outcr.writeln();

After export the data to excel show the result for 長长牀床東东彿佛. But not show the original result 長长牀床東东彿佛

I use the following stmt
responses.setContentType("text/html charset=UTF-8");
Its shows the correct result for chinese character.

I use the below statement
responses.setContentType("application/download; charset=UTF-8");
or
responses.setContentType("application/vnd.ms-excelset;charset=UTF-8");
or
responses.setContentType("application/vnd.ms-excel;charset=UTF-8");

The out put show the in the excel sheet 長长牀床東东彿佛 or some other jung characters.
What can i do here?. After export,I want to show the original chinese character in the excel sheet using the ExcelCSVPrinter.

Thanks & Regards
Thendral

[Nitesh Kant]

CarefullyChooseOneForum while posting.
This is not a distributed java question. Moving to "Other opensource project"

[Martijn Verburg]

Can you set the encoding on the ExcelCSVPrinter?