JRXlsxExporter - xlsx - unreadable content error - max column limit?


 I receive an "Unreadable Content" error from Excel whenever the results of my crosstab report is > 702 columns (column ZZ).   When less than this number of columns - no error.  Is there a limit?  XLSX should handle 16,000+ columns.

We are using JasperReports v4.0.1 and POI 3.6.  I have attempted and recreated this same issue using JasperReports v4.7 and POI 3.7.

Any help or insight is appreciated.


Export Code:

            JRXlsxExporter xlsExporter = new JRXlsxExporter();
            File fileP = new File(_workdir + report_name + ".jrprint");
            JasperPrint jasperPrint = (JasperPrint)

            xlsExporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);
            xlsExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
            xlsExporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
            xlsExporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
            xlsExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, Boolean.TRUE);
            xlsExporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN, Boolean.TRUE);

            xlsExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
            xlsExporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, _outputName);
            System.out.println("Exporting Excel Report to " + _outputName);
            System.out.println("Export Complete.");

matt.kleweno's picture
Joined: Oct 10 2012 - 10:26am
Last seen: 8 years 4 months ago

0 Answers:

No answers yet