I have successfully used POI to generate Excel spreadsheets containing
Japanese text. As Avik says, all I had to do was:
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue(myData);
Best regards,
Robert Lowe
http://RMLowe.com/
-----Original Message-----
From: Avik Sengupta [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 11:28 PM
To: POI Users List
Subject: Re: How to create MS-Excel which contain Japanese strings
encodedin Shift JIS encoding.
Some general thoughts on your requirements
1. People do use POI to read and write sheets with
Japanese/Chinese/Korean/Russian... etc characters in them ... you'll
find that if you search the mailing list.
2. In the same vein, many bugs have been reported in the use of POI with
multibyte characters, many have been fixed, some are still
outstanding... search bugzilla for them.
3. In general, I am not to sure what you mean by "contain Japanese
strings encoded in Shift-JIS encoding". Two things here.. one i am
pretty sure of, one i am guessing a bit. What I am pretty sure of, is
that you are looking at the wrong place to find a method to specify the
encoding...
Remember, you need to specify the encoding where you are converting from
a stream of bytes to a stream of characters. This is the what, for
example java Writers do, so they have the relevant methods. Streams only
work on bytes, so "encoding" is not relevant for them. What POI writes
is a stream of bytes that makes sense to Excel. The conversion from
characters to bytes are done by Excel rules, not Java or Unicode
rules... thats the reason why wb.write(..) takes an OutputStream and
nothing else.
This leads on to my other point, where i might stand corrected. Why to
you want to specify the "Shift-JIS" encoding? Usually, environments have
their own internal encoding, and you need to specify you own encoding
only while doing IO. So Java internally uses UCS16 (aka UTF-16) for all
in memory characters/strings. You need to specify the encoding only if
you are reading or writing a file, or storing it in a database etc.. ie,
moving it in/out of the JVM's memory. So excel, AFAIK, has its own
internal encoding representation, (which i think is a variation of
UTF-16 for double byte characters..) .. so i dont understand why you
insist on storing characters in Shift-JIS in Excel.. .
Ok, to cut a long story short, all that should be needed is
cell.setCellEncoding(..) //set this to take double byte chars
cell.setCellValue(someJavaStringVariableContainingJapanese);
Hope this makes sense ... its too late at night for me to make sense :).
Shout if you have any questions.
Regards
-
Avik
On Wed, 2003-10-22 at 18:53, Mudit Gupta wrote:
>
>
>
>
> Hi All,
>
>
>
> We are planning to use POI for creating an XLS file from a J2EE based
> application.
>
>
>
> The application server is WebLogic 8.1, OS is Solaris 8.
>
>
>
> However, the XLS to be created will contain Japanese strings encoded
> in Shift JIS encoding.
>
>
>
> After checking the POI API, what we found there is no place where one
> can specify the encoding of the XLS file to be created. Typically it
> is done through OutputStreamWriter of java.io. However, the relevant
> APIs (wb.create(java.io.OutputStream stream))in POI, which can be used
> to write strings in the XLS file, accepts only OutputStream object.
>
>
>
> In this situation, can anyone please let us know how POI can be used
> to create a XLS file with Japanese strings encoded in Shift_JIS ?
>
>
>
> Regards,
>
> Sourav
>
>
>
> ______________________________________________________________________
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
