Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-5458

Improve MS Excel export time by switching to streaming version of POI API

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Severity: High
    • Resolution: Unresolved
    • Affects Version/s: 5.3.0 GA, 7.1.0.12 GA, 8.0.0 GA, 8.1.0 GA, 9.0.0 GA
    • Fix Version/s: Backlog
    • Component/s: Report Generation
    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      Currently when customers are exporting PRD reports using MS Excel 2007 or XLSX they are running into performance issues in comparison to running the reports in MS Excel 97 (xls).

      Considering there is a hard limitation of 65k rows to be exported using MS Excel 97 we cannot provide a workaround for users running exports higher than 65K rows.

      For reproduction steps; sample data and sample report demonstrating this issue please see ESR-4689

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              clopez Carlos Lopez
              Votes:
              5 Vote for this issue
              Watchers:
              19 Start watching this issue

                Dates

                Created:
                Updated: