XLSX Export inserts Page Breaks

XLSX Export inserts Page Breaks

Posted by: travis.beltrametti on 6 January 2026, 8:40 am EST

• 

  travis.beltrametti

  • Post Options:
  • Link
    Copy

  Posted 6 January 2026, 8:40 am EST - Updated 6 January 2026, 9:32 am EST

  We are using Active Reports js viewer in Angular and MVC Backend.

  We have a XLS Export which we export using this command:

  this.viewer.export('Xls', undefined, true, { fileName: this.reportFileName })

  We’d like to switch to export xlsx, to support the newer format

  this.viewer.export('Xlsx', undefined, true, { fileName: this.reportFileName, multiSheet: false }

  But now the export is different. We already could solve 1 issue by setting multiSheet to false, but the remaining issue is, that the export no contains page breaks. (In contrary to xls).

  This export for xlsx differs and is bad for our customers:

  

  1592×1385 584 KB

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 7 January 2026, 1:57 am EST

  Hi Travis,

  As per our observation:

  • With Page/RDL Reports (RDLX): XLS/XLSX, both exports show page breaks as expected, by splitting content into different pages when a page break is encountered.
    
    This behavior was found consistent with XLS and XLSX exports for RDLX reports.
  • With Section Reports (RPX): XLS/XLSX, both exports render as continuous sheet (ignoring page breaks), and the ‘Multipage’ property for the export is set to ‘false’ by default.
    
    Enabling it splits each report page into different pages in the Excel sheet.
    
    This behavior was also found consistent with XLS and XLSX exports for RPX reports.

  We have attached our sample for your reference.

  However, if in your case with RPX reports, you are getting content in different pages with Page Breaks, then please share a sample application that replicates the issue so we can test the same on our end and further investigate the same.

  Regards,
  
  Anand

  ReportWithPageBreaks(RPX).zip
  
  ReportWithPageBreaks(RDLX).zip

• 

  travis.beltrametti

  • Post Options:
  • Link
    Copy

  Posted 8 January 2026, 8:47 am EST

  Hi Anand

  Thanks for you response. It is in fact the 2 exports do not create the same result. The left side is created with

  this.viewer.export('Xls', undefined, true, { fileName: this.reportFileName })
  

  The right side is created with:

  this.viewer.export('Xlsx', undefined, true, { fileName: this.reportFileName, multiSheet: false }

  We’d like to use xlsx but get the style on the left (without page breaks).

  Can you help us there?

• 

  travis.beltrametti

  • Post Options:
  • Link
    Copy

  Posted 8 January 2026, 8:48 am EST - Updated 8 January 2026, 8:53 am EST

  Here is the image

  

  3058×1045 239 KB

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 9 January 2026, 5:05 am EST

  Hi Travis,

  Unfortunately, we tried to replicate the issue by trying to use the viewer.Export method. However, we observed that with ActiveReports 19, the viewer.Export expects the rendering extension object you want to export your report with, instead of passing the string value.

  Could you please let us know which version of ActiveReports you are using so we can test and replicate the issue on our end, if possible please try sharing a minimal replicable sample that replicates the issue so we can test the same on our end and further investigate the issue, or share it with our development team in case of a bug.

  Thanks,
  
  Anand

• 

  travis.beltrametti

  • Post Options:
  • Link
    Copy

  Posted 9 January 2026, 5:36 am EST

  Hi Anand

  We are using AR 17. I’m pretty sure you can reproduce it with this version.
  
  For exporting were using ActiveReportsJs with this command:

  this.viewer.export('Xlsx', undefined, true, { fileName: this.reportFileName, multiSheet: false })

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 12 January 2026, 6:59 am EST

  Hi Travis,

  Sorry, we tried to replicate the issue with ActiveReports 17 by using the SectionReport file in both WinForms and JSViewer, and tried to export with the same settings, but in our experience, we could observe both XLS and XLSX exports to be similar in ActiveReports 17 when using the same report file.

  We have attached our sample applications. Could you please try using your report files in our application and see if the issue is replicated? If it does, then can you please share the modified sample so we can test the issue on our end and further investigate the issue?

  Thanks,
  
  Anand

  ActiveReports17Application.zip
  
  JSViewer_MVC.zip

• 

  travis.beltrametti

  • Post Options:
  • Link
    Copy

  Posted 12 January 2026, 7:06 am EST

  It doesn’t make sense, that I replicate your working version - I think you need to try to replicate my non-working version. Please note that we have rdlx files. (not section reports).

  I’ve attached a sample report. The problem can be reproduced will ALL reports we have.

• 

  travis.beltrametti

  • Post Options:
  • Link
    Copy

  Posted 12 January 2026, 7:07 am EST

  sample
  
  Adress-Export.zip

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 13 January 2026, 2:30 am EST

  Hi Travis,

  Thank you for clarifying that you are working with PageReports (RDLX). After some discussion with my peers, for PageReports, setting the ‘Multisheet’ property exports each page on a separate sheet in the Excel export.

  As you have also set ‘Multisheet’ to ‘false’, your entire report preview exports to a single page. This is an expected behavior.
  
  Could you please tell us more about the issue you solved by setting multiSheet to false here: “We already could solve 1 issue by setting multiSheet to false”, so we can find a solution/workaround based on your use case.

  Thanks,
  
  Anand

• 

  travis.beltrametti

  • Post Options:
  • Link
    Copy

  Posted 13 January 2026, 3:39 am EST - Updated 13 January 2026, 3:44 am EST

  Hi Anand
  
  We had 2 issues. After changing xls to xlsx then the report exported to multiple sheets. With the setting multisheet=false this was resolved. The result is now again shown in 1 sheet. But the problem remains, that every page break appears in the result in contrary to xls were the data is just shown as a continuous list.

  Please refer to the shared image, you see what the issue is:
  
  

  

  3058×1045 239 KB

• 

  anand.sinha

  

  • Post Options:
  • Link
    Copy

  Posted 14 January 2026, 7:03 am EST

  Hi Travis,

  Thank you for explaining your entire scenario; it helps us understand your entire use-case very well.
  
  In your case, as you’d like to only show the data continuously in a single sheet without the headers/footers repeating from every page onwards (after/before page breaks) we’ll suggest exporting your report to “XlsxData”.

  The “XLS” or “XLSX” exports the report just as a preview. That is, in preview, every page shows a header, then certain rows of data, and then shows the footer. The same format is followed when exporting to Excel. Whereas “XLSXData” is used when only the Data of the report needs to be exported.
  
  Do note that XLSX Data may not export certain styling, images, etc., in the exported file.
  
  Excel Data exports only data from Tablix, Table, and Matrix data regions, preserving the data region structure and ignoring layout-related features (page break, cumulative total, etc). Other controls and data regions of the original report are ignored at this export.
  
  You can learn more about XLSXData export here: Excel Data Export.

  However, if you’d like to only use the regular XLSX Export, then you’ll need to manually hide/remove the extra controls that you do not want to include in the export, also set the ‘Pagination’ property to ‘false’ so that there are no blank spaces in the Excel export (representing spaces in your report preview).

  Unfortunately, we were unable to test the exports with your shared files due to the unavailability of the SQL Data Source/Sample data. However, if you face any issues, please feel free to reach out.

  Regards,
  
  Anand