ActiveReportsJS 5.2.6 - Export paginated RDLX report to a single continuous XLS

ActiveReportsJS 5.2.6 - Export paginated RDLX report to a single continuous XLS

Posted by: rishi.karki on 13 July 2026, 9:03 am EST

• 

  rishi.karki

  • Post Options:
  • Link
    Copy

  Posted 13 July 2026, 9:03 am EST

  Hi Team,

  I’m using ActiveReportsJS v5.2.6 with an RDLX Page Report and the default Viewer Export functionality.

  My report is designed to be paginated for viewing purposes, which is the desired behavior in the Viewer.

  However, when users export the report to Excel (.xlsx), the output follows the report pagination, resulting in multiple worksheets.

  My requirement is:

  • Keep the report paginated in the Viewer.
  • Continue using the native Export button.
  • Export the report to a single Excel worksheet.

  I would like to know:

  1. Is there any RDLX report property or viewer configuration that controls this behavior?
  2. Is there a way to configure the native Excel export to always generate a single worksheet while leaving the Viewer pagination unchanged?
  3. If this is not supported in v5.2.6, is it available in a newer version of ActiveReportsJS, or is a custom export implementation the only option?

  Any guidance or recommended approach would be appreciated.

  Thank you.

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 14 July 2026, 6:33 am EST

  Hi,

  To answer your three questions directly:

  1. There is no report property or Viewer configuration that controls this today — the Excel (.xlsx) export always maps one worksheet per rendered report page when the report is in paginated mode. The sheetName export setting is only a naming prefix applied per generated sheet, not a way to control sheet count.
  2. This isn’t currently supported as a built-in option — there’s no way to force the native export to single-sheet while leaving the Viewer’s own pagination untouched.
  3. This request is already logged in our product backlog. Internal tracking ID: “ARJ-1789”. There’s no committed ETA on this right now, but we’ll update this thread as soon as we have anything concrete to share.

  In the meantime, here’s a workaround that gets you a single continuous worksheet without changing how readers view the report day-to-day:

  The Report Viewer exposes a public renderMode property (‘Paginated’ | ‘Galley’). Default is ‘Paginated’, which is why export follows the same page-by-page layout as the screen. Switching to ‘Galley’ renders the report as one continuous flow, and an Excel export taken from that state produces a single worksheet.

  Reference: https://developer.mescius.com/activereportsjs/api/classes/ReportViewer.Viewer#rendermode

  Since you want the Viewer to stay paginated for viewing and only the export to be single-sheet, flip the mode only around the export call, using the Viewer’s own export() method, then flip it back:

  async function exportSingleSheetExcel(viewer, filename = 'report.xlsx') {
    const previousMode = viewer.renderMode; // 'Paginated'
    viewer.renderMode = 'Galley';
    try {
      const result = await viewer.export('xlsx', { /* your usual xlsx export settings */ });
      result.download(filename);
    } finally {
      viewer.renderMode = previousMode; // restore paginated view
    }
  }

  Wire this to a custom toolbar button in place of the built-in Excel export item (see our doc on adding custom export buttons: https://developer.mescius.com/activereportsjs/docs/DeveloperGuide/ActiveReportsJSViewer/Export and https://developer.mescius.com/activereportsjs/demos/features/viewer-customization-toolbar/purejs).
  
  Readers keep the paginated view at all times, and the mode only flips for the moment the export runs.

  You may also find this earlier thread useful, where we discussed single-sheet/CSV export for ActiveReportsJS: https://developer.mescius.com/forums/activereportsjs/how-to-export-csv-using-activereportsjs

  Thanks,
  
  Priyam

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 17 July 2026, 5:52 am EST

  Hi,

  The devs mentioned that The Excel export engine was completely redesigned in v6.0, and it introduces a fundamentally different sheet-mapping strategy:

  “It now generates a separate sheet for each report section (not per page) in Continuous and Pageless report layouts.”

  This means that in v6.0+, a single-section Continuous Page Layout report will export to a single Excel worksheet, regardless of how many viewer pages the report spans. Your requirement — paginated viewer with a single Excel sheet — is directly addressed by this new behavior.

  We recommend upgrading to v6.0 or later to natively fulfill your requirement.

  Best regards,
  
  Priyam

• 

  rishi.karki

  • Post Options:
  • Link
    Copy

  Posted 17 July 2026, 8:17 am EST

  Thanks Priyam for the update.