Technical concerns

Aspose.Cells Product Family
1
Hi team,

My primary concern is to export some more advanced excel sheets from SSRS.
I am yet to get it working with Visual Studio 2012 (Trying out the demo).
It is throwing errors in all excel formats right now (See below).
This is a simple tablix report that groups data and creates a new sheet per group (This worked before installing aspose).

An error occurred while exporting the report.
error message Worksheet name could not contain any following characters : : \ / ? * [ or ]
stack trace at —.–. (String )
at —.–. (String )
at Aspose.Cells.WorksheetCollection. (String )
at ™.€.(String pagename)
at š.. (String pageName, Boolean isHead)
at š.. (TablixMember tm, 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)

Best regards,
Viggo Stenseth

This message was posted using Email2Forum by Sabrina Tran.
2

Hi Viggo,

Your issue is related to Aspose.Cells for Reporting Services, so I am moving this thread to Aspose.Cells forum where one of my colleague will assist you regarding your reported issue.

Thanks & Regards,

3

Hi,


Thanks for providing us some details.

Well, MS Excel file format does not allow to name a sheet having invalid chars i.e., " :\ / ? * [ or ]", so please make sure that you do not name a sheet with such chars in your report definition file, this is the limitation of MS Excel. If you still think this is an issue with Aspose.Cells for RS, kindly provide us your sample RDL file and MS Excel renderings to properly evaluate your issue on our end, we will check it soon.

Thank you.