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
