File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Servlets and the fly likes sql to excel with java character problem. Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of Mongo DB Applied Patterns this week in the MongoDB forum
or a resume review from Five Year Itch in the Jobs Discussion forum!
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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: sql to excel with java character problem.
 
Similar Threads
How to export the chinese character to excel using ExcelCSVPrinter. Open the file within browser
Exporting HTML Data to excel issue
display of japanese characters in excel sheet
How to output JSP page to Excel ?
Opening Excel sheet in a browser