Forums Register Login

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

+Pie Number of slices to send: Send
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

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


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
+Pie Number of slices to send: Send
CarefullyChooseOneForum while posting.
This is not a distributed java question. Moving to "Other opensource project"
+Pie Number of slices to send: Send
Can you set the encoding on the ExcelCSVPrinter?
Can you really tell me that we aren't dealing with suspicious baked goods? And then there is this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 3429 times.
Similar Threads
webapp - exporting to excel problem with csv
Opening excel sheet separately
display of japanese characters in excel sheet
file name issue
Printing contents
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 16:09:47.