You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by hotmail <al...@hotmail.com> on 2003/07/14 08:49:05 UTC

how can set the Excel sheet name in some languangs

Emergency!!!
How can set the Excel sheet name in some languages which are not English, such as Japanese, Chinese.
HSSFWorkbook.setSheetName(int i, String str) doesn't work correctly with Chinese.
HSSFWorkbook.createSheet(short s, String str) does either.

Re: how can set the Excel sheet name in some languangs

Posted by Ma Yaohua <ma...@koal.com>.

SET CHARECTSET  UNICODE
----- Original Message ----- 
From: "hotmail" <al...@hotmail.com>
To: "poi" <po...@jakarta.apache.org>
Sent: Monday, July 14, 2003 2:49 PM
Subject: how can set the Excel sheet name in some languangs


> Emergency!!!
> How can set the Excel sheet name in some languages which are not English, such as Japanese, Chinese.
> HSSFWorkbook.setSheetName(int i, String str) doesn't work correctly with Chinese.
> HSSFWorkbook.createSheet(short s, String str) does either.
>

Re: how can set the Excel sheet name in some languangs

Posted by Janarthan S <ja...@akshay.co.in>.

Hi,

If you download the latest release POI Release pre2 from the site, you can
do something like -
  HSSFSheet mFirstSheet = mWorkbook.createSheet();
  mWorkbook.setSheetName(0, "SheetName", HSSFCell.ENCODING_UTF_16);

where mWorkBook is an instance of HSSFWorkBook.
This will take care of setting the sheet names in any languages.

Regards,
Janarthan S


----- Original Message ----- 
From: "hotmail" <al...@hotmail.com>
To: "poi" <po...@jakarta.apache.org>
Sent: Monday, July 14, 2003 12:19 PM
Subject: how can set the Excel sheet name in some languangs


> Emergency!!!
> How can set the Excel sheet name in some languages which are not English,
such as Japanese, Chinese.
> HSSFWorkbook.setSheetName(int i, String str) doesn't work correctly with
Chinese.
> HSSFWorkbook.createSheet(short s, String str) does either.
>