Must admit that I forgot about JExcel completely. Have had a quick look on Andy
Khan's wb page (http://www.andykhan.com/jexcelapi/index.html) and found this;
Excel Versions
JExcelApi will read workbooks created in Excel 95, 97 and 2000, and
will generate workbooks that can be read by Excel 97 and later.
Do not know if that helps.
--- On Thu, 10/23/08, Christian Gosch <[EMAIL PROTECTED]> wrote:
From: Christian Gosch <[EMAIL PROTECTED]>
Subject: RE: Reading Excel 5.0/7.0 files
To: "user" <[email protected]>
Date: Thursday, October 23, 2008, 12:29 AM
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]
