• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6104
  • 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
 
Jorge PaulinoIT Pro/DeveloperCommented:
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
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)PresidentCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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