Many problems with encoding have been fixed in later versions of POI.
Can i ask you to try the same code with th 2.0pre release?
Thanks
-
avik
On Mon, 2003-06-16 at 15:12, Henning Schmiedehausen wrote:
> Hi,
>
> I'm trying to read an Excel 97 spreadsheet which contains two columns
> of strings. These might contain german umlauts.
>
> Unfortunately, POI returns "?" for these characters and does not
> encode them correctly in Unicode. Is there any way for me to work
> around this?
>
> Basically I do
>
>
> String xlsFileName = "workbook.xls";
> String sheetName = "Sheet_1";
>
> POIFSFileSystem fs =
> new POIFSFileSystem(new FileInputStream(xlsFileName));
> HSSFWorkbook wb = new HSSFWorkbook(fs);
> HSSFSheet s = wb.getSheet(sheetName);
> HSSFRow row = null;
> int rowIndex = 0;
>
> while((row = s.getRow(rowIndex++)) != null)
> {
> HSSFCell cell = row.getCell((short)1);
> String value = cell.getStringCellValue();
> System.out.println("String is " + value);
> }
>
> And the string contains "?" where in the spreadsheet I have "���".
>
> Any ideas? I use POI 1.8.0-dev-20020919 with JSDK 1.4.1_02
> on RedHat Linux 7.3
>
> Regards
> Henning
--
Avik Sengupta <[EMAIL PROTECTED]>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
