• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5963
  • Last Modified:

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

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.
issue.JPG
0
Tapan Pattanaik
Asked:
Tapan Pattanaik
2 Solutions
 
jpaulinoCommented:
You can export the report as CSV file, then create a new Excel File (*.xlsx) and import the CSV created file.

0
 
VipulKadiaCommented:
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.
0
 
Tapan PattanaikSenior EngineerAuthor Commented:
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.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Tapan PattanaikSenior EngineerAuthor Commented:
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.
0
 
Jacques Bourgeois (James Burger)Commented:
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.
0
 
aikimarkCommented:
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.
http://www.experts-exchange.com/A_2253.html
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now