Hi,
just tried this this morning with the current CVS HEAD. No change in
behaviour. :-(
Regards
Henning
On Mon, 2003-06-16 at 12:57, Avik Sengupta wrote:
> 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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
