Export to Excel Error - same worksheet name already exists

Aspose.Cells Product Family
1

We recently upgraded to version 2.0 of Aspose Cells for Reporting Services. We are getting an error message as follows

How can I verify that I have done the upgrade properly and then how do I fix this error without rewriting the report to put in worksheet (page) names?

An error occurred while exporting the report.

error message

The same worksheet name already exists

stack trace

at —.–.(String )
at —.–.(String )
at Aspose.Cells.WorksheetCollection.(String )
at ™.€.(String pagename)
at š.
.(String pageName, Boolean isHead)
at š.
.( tm, Int32 left, Int32 top)
at š.
.( tm, Int32 left, Int32 top)
at š.
.Š()
at š.
.()
at ™…(ReportItemCollection reportItems)
at ™…()
at ™.“.()
at ™.“.(” workbook)
at Aspose.Cells.ReportingServices.Renderer.(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)
at Aspose.Cells.ReportingServices.Renderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)

2

Hi Dan,

Thanks for using Aspose.Cells for Reporting Services.

We have fixed the similar issue in the recent version. Let us know your Reporting Services version. The fix given below is for SSRS 2008R2. If you are using some other version like SSRS 2008 or SSRS 2012 then let us know.

Please try the fixed version: Aspose.Cells for Reporting Services V2.1.0.18 (SSRS2008R2).

Please copy Aspose.Cells.ReportingServices.dll into following folder:

${SQL Server 2008 R2 Reporting Services}\Reporting Services\ReportServer\bin.

Please let us know your run results.

3

Good morning. We copied the DLL to the folder as indicated above. We do have SSRS 2008R2. I have attached the error message when exporting a report to excel via aspose after the new DLL was replaced and the services restarted. I have also attached a snapshot of the DLL properties to make sure we are using the correct one.

Thank you.

4

Hi Dan,

Thanks for your feedback and using Aspose.Cells.

Please also provide us your RDL file which is causing this error while exporting the report to XLSX format using Aspose.Cells for Reporting Services.

5

Here is the RDL file. I don't believe we've had an issue with this previously, but I know we are able to use the normal excel export, so we may not have come across this issue before.

Thank you.

6

Hi Dan,

Thanks for your file and using Aspose.Cells for Reporting Services.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • SSRS-40202 - Export to Excel Error - same worksheet name already exists

7

Hi,

We have found the issues and fixed them.

Please try the fixed version: Aspose.Cells for Reporting Services (SSRS2008R2) V2.1.0.20 (attached).

Please copy Aspose.Cells.ReportingServices.dll into following folder : ${SQL Server 2008 R2 Reporting Services}\Reporting Services\ReportServer\bin.

Please let us know your run result.

Thank you.

8

The issues you have found earlier (filed as SSRS-40202) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.