aspose file tools
The moose likes Java in General and the fly likes Problem in writing japanese characters into an XLS file through a Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » Java in General
Reply Bookmark "Problem in writing japanese characters into an XLS file through a "JAVA" program" Watch "Problem in writing japanese characters into an XLS file through a "JAVA" program" New topic
Author

Problem in writing japanese characters into an XLS file through a "JAVA" program

Sat Nar
Ranch Hand

Joined: Oct 22, 2004
Posts: 83
Friends,
iam in the process of generating EOD reports.The data in the table is to be populated into XSL file.Iam using HSSF and POI for this.Everything is fine.But when populating these japanese characters, its populated as junk characters.I even tried storing these japanese characters in the table in NCR format.But iam not able to reconvert back these NCR format into Japanese characters.The xsl file creation should happen only by JAVA program.Kindly tell me how japanese characters should be stored in the table whether in NCR format or in anyother format and how to populate japanese characters in XLS.Awaiting your replies.

Regards,
Sathya
Stuart Ash
Ranch Hand

Joined: Oct 07, 2005
Posts: 637
First off, it's called Java, not JAVA.

Can you tell more about the encoding settings in your program.


ASCII silly question, Get a silly ANSI.
Vlado Zajac
Ranch Hand

Joined: Aug 03, 2004
Posts: 244
HSSFCell documentation, method setEncoding.

Set it to ENCODING_UTF_16.
Sat Nar
Ranch Hand

Joined: Oct 22, 2004
Posts: 83
Hi,
thanka a lot for your reply.Its perfectly working now.

Regards,
Sathya
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Problem in writing japanese characters into an XLS file through a "JAVA" program
 
Similar Threads
Unicode usage
Retrieving japanese characters through jdbc
how to show Japanese in jsp properly?
Internationalization
Retrieving japanese characters through jdbc