We are in the process of upgrading Jasper verion from 2.+ to latest version preferrably 5.0.0 for generating 2007 compatible excel reports. As mentioned in the blogs and suggested by community, we are using JRXlsxExporter for exporting the data into xlsx format. We are able to generate xlsx file with JRXlsxExporter but on opening it we are receiving Excel found unreadable content in xslx file for every excel report. On going through Microsoft site, it says some of the xlsx files generated by third party packages are not fully compliant with 2007 excel format but, I see few folks based on their questions and answers that they are able to generate 2007 excel files in this community. Generated xslx report which gives error is attached to this question for your review. Prior to upgrade, we are using JExcel for generating xls reports and we were fine but JExcel is not able to generate 2007 file.
iReports is able to generate the xlsx format file successfully as I don't see such error on opening the file generated by it. What is that we are missing?. Is JRXlsxExporter able to generate 2007 excel report or do we have to use some other functionality? There should be a way as iReports is able to generate it. Can you please help us.
JRXlsxExporter exporterXLSXReporter = new JRXlsxExporter();
exporterXLSXReporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, new Boolean(false));
We have tons of reports that need to be migrated from 2003 to 2007.