Hello,
I use the last beta version of apache poi to read data in excel spreadsheet.
But, unfortunaly, files created or modified with Excel 2003 can't be
used with apache POI.
It work fine with files created by OpenOffice or older version of Excel.
This exception thrown:
java.lang.IllegalArgumentException: Your InputStream was neither an OLE2
stream, nor an OOXML stream
at
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:64)
.............
The source code is easy:
try
{
InputStream inp = new FileInputStream(file);
Workbook wb = WorkbookFactory.create(inp);
// .......
}
catch (Exception e)
{
e.printStackTrace();
}
My problem is all the Excel files to be read have been created with
Excel 2003 and I can not ask my customers to convert with openoffice...
Are you planning to support this new Excel 2003 xls format soon?
Or do you know a method/java class to convert Excel 2003 xls files to
the previous Excel file format working with POI?
Regards,
Patrick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
