SSRS Export to excel(.xls) issue - Version 8.3.4 - VisualCron - Forum

Community forum

Vasanth
2018-08-16T17:47:22Z
Hi,

We have an SSRS report which exports more than 65K data to excel file. The report fails midway due to excel(1997-2003) restriction of 65K rows. Is there an option to export the SSRS report to excel 2007 format.

Any help, will be greatly appreciated.

Error:
Exception in Task: Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 67861. Maximum rows: 65536. ---> Microsoft.ReportingServices.ReportProcessing.HandledReportRenderingException: Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 67861. Maximum rows: 65536. ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 67861. Maximum rows: 65536.

Thank you.
thomas
2018-08-17T08:59:28Z
Have you tried the ExcelOpenXml format?
Scroll to Top