Jump to content

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


Recommended Posts

 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.");

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...