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
--
Dipl.-Inf. (Univ.) Henning P. Schmiedehausen INTERMETA GmbH
[EMAIL PROTECTED] +49 9131 50 654 0 http://www.intermeta.de/
Java, perl, Solaris, Linux, xSP Consulting, Web Services
freelance consultant -- Jakarta Turbine Development -- hero for hire
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
