You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by teena21 <fr...@yahoo.com> on 2007/11/06 06:51:49 UTC

how to read unicode data from xls sheet

i want to read a unicode data from an excel sheet by using HSSF it doesn't
show unicode data.
can i read or set the unicode data into a cell by using HSSF
-- 
View this message in context: http://www.nabble.com/how-to-read-unicode-data-from-xls-sheet-tf4756220.html#a13601249
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Re: how to read unicode data from xls sheet

Posted by Nick Burch <ni...@torchbox.com>.
On Mon, 5 Nov 2007, teena21 wrote:
> i want to read a unicode data from an excel sheet by using HSSF it 
> doesn't show unicode data.

If the cell is set to unicode, then when you read a string out of it, poi 
will give it to you as unicode.

If you want to put unicode into a cell, just save it, and poi will do the 
right thing. (You don't need to set the encoding to 
HSSFWorkbook.ENCODING_UTF_16 any more, as that's all handled internally 
for you)

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org