Free Support Forum - aspose.com

Report Services to Excel exceeds 66-000 rows

Aspose.Cells Product Family
#1

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.
#2

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

#3

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?

#4

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

#5

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

#6

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)