Have you looked into using ODBC to strip the data from the Excel files for you? Have a look at this link
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.ii.doc/opt/tlsodb13.htm As a technique, it does not seem anywhere near as flexible as HSSF but it may help you deal with this format because I do not believe there is any API that will read it nor convert it for you. --- On Wed, 10/22/08, Praveen Gattu <[EMAIL PROTECTED]> wrote: From: Praveen Gattu <[EMAIL PROTECTED]> Subject: Re: Reading Excel 5.0/7.0 files To: "POI Users List" <[email protected]> Date: Wednesday, October 22, 2008, 7:47 PM Open and save in Excel is not a viable option since the process is automated and I don't want to introduce a manual step in between. If HSSF cannot handle the older formats, is there another API to convert BIFF5 files to BIFF8? -- Praveen On Wed, Oct 22, 2008 at 6:12 PM, Daniel Noll <[EMAIL PROTECTED]> wrote: > Praveen Gattu wrote: > >> Is there a way POI can read this file? If not, how can I convert this >> BIFF5 >> format file to BIFF8 format file? >> > > Open it and save it in Excel? > > Or add support to HSSF so it can handle these older formats. A lot of > people would thank you. :-) > > Daniel > > > > -- > Daniel Noll Forensic and eDiscovery Software > Senior Developer The world's most advanced > Nuix email data analysis > http://nuix.com/ and eDiscovery software > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- Thanks, Praveen Gattu 303-880-7455
