Excel export - large report yields corrupt file

Posted by: jasonk on 4 August 2017, 2:37 pm EST

  • Posted 4 August 2017, 2:37 pm EST

    Large files generate the following error on export:

    Number: 5026
    Description: ActiveReports Excel Export Error:Internal Error. Pages collection or RDF file may be corrupt.

    Exports on a smaller range or the use of RDF/PDF work fine.  The source of the problem is that the report length is exceeding the maximum length allowed by an Excel spreadsheet.  The historical report in question returns a 1711 page report.
    Each page of the report contains between 50 and 60 rows of data.

    1711 pages x 50 rows = 85,550 rows

    Excel’s row limit on a worksheet is 65,539  < http://support.microsoft.com/default.aspx?scid=kb;en-us;264626>  

    Is there a way for you guys to alter the Excel Export to switch to a second worksheet within the spreadsheet to avoid this issue?

    Thanks.

  • Replied 4 August 2017, 2:37 pm EST

    You can set the MultiSheet property to true. This will force the export to export each page of the report to it's own sheet. While this isn't ideal in some situations, it will allow the report to be exported without being over the Excel row limit.
  • Replied 4 August 2017, 2:37 pm EST

    With all due respect, a 1700+ page Excel document is a little hard to manage.  Custom functions/total summaries would be just a wee bit of a pain for a user to create.  2-3 pages would be managable, 1700+ no.

  • Replied 4 August 2017, 2:37 pm EST

    In that case, the only other possibility is writing the Excel sheet using SpreadBuilder. This will allow you to put everything on the Excel sheets where you want them. Here's a sample from our KB:
    http://www.datadynamics.com/ShowPost.aspx?PostID=377
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels