Jakarta POI failed to read double bytes

[stanley1610]

I have an Excel files consisting of some Traditional Chinese characters and
normal alphabets. When I use HSSFCell::getStringCellValue() to read some Chinese
characters, it returns question marks.

e.g. The cell contains "How are you ???"
The returned value will be "How are you ???"

I also try to add HSSFCell::setEncoding(HSSFCell.ENCODING_UTF_16) before reading
the cell, but the problem still occurs.

Please kindly advise. Thanks a lot.

 

[stanley1610]

I have an Excel files consisting of some Traditional Chinese characters and
normal alphabets. When I use HSSFCell::getStringCellValue() to read some Chinese
characters, it returns question marks.

e.g. The cell contains "How are you 你好嗎"
The returned value will be "How are you ???"

I also try to add HSSFCell::setEncoding(HSSFCell.ENCODING_UTF_16) before reading
the cell, but the problem still occurs.

Please kindly advise. Thanks a lot.