Try to use "jxl" (JExcelAPI) by Andy Khan. It is also open source etc. and has some drawbacks, but the development is driven somewhat more "by practical demand", at least as it was during the last years.
http://jexcelapi.sourceforge.net/ As far as I know the project was not driven by getting an API to handle MS OLE document formats generally in Java, but just handling Excel files for read and write access. It cannot build any internal serializable representation of the data -- to get something storable you must read a given Excel file by the API, or you must stream out a created Excel file to permanent storage. I do not know for sure if it still handles BIFF5, but of course it did. On the other hand, opening the given file for read access using a suitable JDBC/ODBC bridge driver may be a good idea to abstract from the actual file type in your scenario. (as suggested by Anthony Andrews meanwhile) hth, Christian Gosch > -----Original Message----- > From: Praveen Gattu [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 23, 2008 12:58 AM > To: [email protected] > Subject: Reading Excel 5.0/7.0 files > > I have a Java class that reads a MS Excel file generated by a PeopleSoft > reporting tool and loads the data into a Oracle database. The PeopleSoft > reporting tool creates the file in Excel 5.0/7.0 format I guess, cuz when > I > try to read the file, I get the following error: > > The supplied spreadsheet seems to be Excel 5.0/7.0 (BIFF5) format. POI > only > supports BIFF8 format (from Excel versions 97/2000/XP/2003) > > Is there a way POI can read this file? If not, how can I convert this > BIFF5 > format file to BIFF8 format file? > > -- > Thanks, > Praveen > > > !DSPAM:48ffb00b22931434354569! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
