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.
