Free Support Forum - aspose.com

Report Services to Excel exceeds 66-000 rows

Our company builds reports in Reporting Services and exports to Excel. The reason we are interested in Aspose is to overcome the limitation of 66,000 rows in Excel. How would I apply this technology to that problem?


This message was posted using Email2Forum by sheliah.

Aspose.Cells for Reporting Services supports to export file in Excel2007 format. In this way, you can overcome the 65536 rows limitation.

Now when I start up Excel, I get this error:

Public Sub GetCommandPic(commandname As String, pic As stdole.IPictureDisp)
GetAsposeClientTools
Set pic = AsposeClientTools.GetPic(commandname)
End Sub

Can you help me with this?

I am running Excel 2007, I have the Aspose.Cells evaluation copy installed. When I try to export to Excel, 2007, I get the attached error.

Thank you in advance to any assistance you can provide with this issue.

Randy

Hi rrogge,

When Excel 2003 loads Aspose.Cells.ReportingServices.Client add-ins ,Excels produces an automation error. Please update to office 2003(KB907417) or office 2003 SP1.

Reference to http://www.aspose.com/documentation/ssrs-rendering-extensions/aspose.cells-for-reporting-services/system-requirements.html

Hi rrogge,

I check your error document.

I found you select Excel format to export data.

When you export more than 66000 rows data through Excel format , SSRS produce server error(Excel Rendering Extension : Number of rows in the Excel sheet exceeded the limit of 65536 rows).

Please install Aspose.Cells.ReportingServices and select Excel2007Xslx - Excel 2007 via Aspose.Cells format to export data.

Please try the latest Aspose.Cells.ReportingServices.( http://www.aspose.com/community/files/52/ssrs-rendering-extensions/aspose.cells.reporting.services/entry125756.aspx)