Excel Rendering Extension: Number of rows exceeds the maximum possibel rows per sheet in this format; Rows Requested: 68750, Max Rows: 65536

Posted on 2011-10-17
Last Modified: 2012-05-12
Hi Experts,

We are getting problem, when we are exporting data more than 66000 rows  from .RDLC report to Excel, we are getting exception "Excel Rendering Extension: Number of rows exceeds the maximum possibel rows per sheet in this format; Rows Requested: 68750, Max Rows: 65536" . Even we are using Excel 2007 and Excel 2010 versions. We have attached one image for your refrence. This is very critical issue.

We are using 7 field groups in this .RDLC report.
Question by:Tapan Pattanaik
    LVL 48

    Expert Comment

    You can export the report as CSV file, then create a new Excel File (*.xlsx) and import the CSV created file.

    LVL 8

    Expert Comment

    Evenif you are using Excel version 2007 or 2010, just check you DON'T give the extension as '.xls'. Keep extension as either .xlsx or .xlsm.
    LVL 20

    Author Comment

    by:Tapan Pattanaik
    Hi Experts,

    This .XLS feature is internal defined in .RDLC report viewer. We can not change it, If there is any possiblity please let me know how to change the extension from .XLS to XLSX.
    LVL 20

    Author Comment

    by:Tapan Pattanaik
    Hi jpaulino,

    how it is possible, I am using 7 field groups in .RDLC report. .RDLC report viewer contains only three options. 1)- EXCEL 2)- PDF 3)- WORD.
    Please explain me clearly about the process.

    Thank You.
    LVL 40

    Accepted Solution

    Unfortunately for you, present versions of the ReportViewer do not support exporting to .xlsx. One of the many reasons a lot of companies stick to Office 2003.

    This is one of the new features of the next version of SQL Server (in beta under the name Denari) that will be included in the next version of Visual Studio.

    You will find the following cited in many places in MSDN

    RDLC Designer and Report Viewer Control: Have been upgraded with Reporting Services “DENALI” code base (Including support for DOCX, XLSX Export, Map functionality, RDL 2010 schema support…). Starting with the next release of Visual Studio, RDLC and Report Viewer will ship with the same level of functionality of the most current release of SQL Server.

    For now, the only solution is to export in another format (.csv, .xml) and then import the result in to the .xlsx document.
    LVL 44

    Assisted Solution

    use CopyFromRecordset method for a range.

    You will need to instantiate an Excel application object and open the target workbook.

    You can also push the data directly from a two dimension array as I described in this Fast Data Push to Excel article.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
    The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now