wood burning stoves*
The moose likes Servlets and the fly likes sql to excel with java character problem. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Reply locked New topic
Author

sql to excel with java character problem.

Doug Douglas
Greenhorn

Joined: Aug 04, 2011
Posts: 2
Non-English Values are looking like upside with their charsets.

"application/vnd.ms-excel; charset=cp1254";

Values on Excel is : ??? ??? ??? ??? ???

"application/vnd.ms-excel; charset=UTF-8";

Values on Excel is : ÊÖÇÑÈ ÊæŞÚÇÊ ÔåÑ ÃßÊæÈÑ İí ÓæŞ ÇáÜPP

If I open excel and import it with utf-8,values looks great,but everytime opening file with importing is problem for customers. I found this code below written with ASP.NET,but couldnt write with JAVA. Also I am not sure this code will solve my problem.
Response.ContentEncoding = System.Text.Encoding.Default;
Vijay Tidake
Ranch Hand

Joined: Nov 04, 2008
Posts: 146

Hi,

try the example int this thread.

Hope this helps.
Thanks


The important thing is not to stop questioning.Curiosity has its own reason for existing.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: sql to excel with java character problem.
 
Similar Threads
Opening Excel sheet in a browser
How to export the chinese character to excel using ExcelCSVPrinter. Open the file within browser
How to output JSP page to Excel ?
display of japanese characters in excel sheet
Exporting HTML Data to excel issue