Hi Karl, Thanks for your prompt response. I have already seen that thread about using OOo for format conversion. But I am unable to figure out how to use it. The solution I am looking for, is like a JAR file, you simply port it with your application, and this JAR file contains all the necessary java classes to allow me to use the OO-UNO API and thus allow me to do the conversion. >From the SDK I can figure out that, I will have to compile the code separately, create such a JAR file manually and then add it to my project, which seems a very long process to me. Is this the only way or am I simply exaggarating the effort involved?
Thanks, Suyog ----- Original Message ----- From: "KHZ (SAW)" <[EMAIL PROTECTED]> To: "'POI Users List'" <[email protected]> Sent: Wednesday, July 26, 2006 3:36 PM Subject: AW: How to use POI for reading Excel 2.1 format? Hi Suyog. With OpenOffice.org (OOo) you can do it using Java. Just look at the thread about how converting from Excel 95 (the version below) which was just 2 days ago. In your case it's just the other direction (some version above). Regards, Karl-Heinz. -----Ursprüngliche Nachricht----- Von: Suyog Mahajan [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 26. Juli 2006 12:08 An: [email protected] Betreff: How to use POI for reading Excel 2.1 format? Hi, I have this requirement of reading and then processing the read data from an Excel file which is in Excel 2.1 format. I have tried using POI, but my experience was that POI works well for Excel 97 above, which definitely excludes Excel 2.1 format. Now there are 2 solutions: a) Either I convert manually all the excel files into Excel 2000 format by opening them using MS Office. Which SHOULD NOT be done, because as per requirement everything needs to be done using Java code. b) Either find a way using Java to convert the file format, or use a totally different Java API which might support Excel 2.1 formats. (I have also tried using JDBC-ODBC DSN for Excel, but it also fails for this old format). The system I am working on, has office 2000 installed on it, and these excel files are obtained from external server. Any help in this regard will be highly appreciated. Thanks. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
