You did the right thing. The UTF_16 is a misnomer carried from the earliest
versions of POI. In 3.0 these will be renamed to "EIGHT_BIT_CSET and
SIXTEEN_BIT_CSET" or something. The first case is useful only for US
character sets. The only problem is how to name this concisely and clearly
(because there are some eight bit character sets that excel writes in 2
bytes because Excel is a silly format).
-Andy
On 8/1/03 2:31 AM, "Xuemin Guan" <[EMAIL PROTECTED]> wrote:
> Hello, dear all, I am having some problems dealding with
> Japanese Characters. I set up a cell value as this:
> cell.setCellValue("some Japanese characters go here");
>
> And I end up with wrong values in the generated XLS file.
>
> Then I looked up the POI API and souce code, and did the follow:
>
> cell.setEncoding((short)1);//Using UTF_16
> cell.setCellValue("some Japanese characters go here");
>
> Then it worked fine. But I am not sure if this is the
> right thing to do. Doesn't the POI/Excel supports something
> like setting up the encoding using Shift_JS, ISO-8859-1
> these stuff? Or I only have a choice between
> ENCODING_COMPRESSED_UNICODE and or ENCODING_UTF_16?
> And the thing I did was just right?
>
> Any hint will be highly appreciated.
>
> Best,
>
> Xuemin
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
--
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI
http://jakarta.apache.org/poi
For Java and Excel, Got POI?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
