Hi,
I made an utility applications that reads an excel file and outputs XML
using POI (poi-2.5.1-final-20040804.jar).
It all worked fine until my input excel was edited/changed with Excel 2003,
where funny things started to happen.
As a workaround I tryed so save the input excel file as Microsoft Excel
97(-2002) from excel and submit back to the utility.
Unfortunately I found that once the excel file is changed with Excel 2003
the POI lib becomes unable to read this file even
if I save it as Microsoft Excel 97(-2002).
Additionally I found the following:
- If I converted the input excel file using OpenOffice to Microsoft
Excel 97(-2002) and submit to the utility it all
works fine. But I don't have full control of the excel file and can't
ask users to use OpenOffice.
- If I convert the input file using Excel to Microsoft Excel 97(-2002)
using Excel the generated file as 2 times size of the
original one.
Did anyone face a similar problem and how did you solved it.
Thanks, Luis
