We have recently installed Aspose.Cells on SSRS 2008, dll version is 184.108.40.206
I have a report in SSRS 2008, built in SSRS 2008 R2. This report runs ok, and when exporting results using MS Excel the file gets exported fine. However, when I try to export results using "Excel2007Xlsx - Excel 2007 via Aspose.Cells" I get a single worksheet "ERROR" instead of 5 worksheets that report creates, this error worksheet contains the following:
Error: The same worksheet name already exists
Stack Trace: at Aspose.Cells.x59e54927437fee85.set_x759aa16c2016a289(String xbcea506a33cf9111)
at Aspose.Cells.ReportingServices.ReportItem.x593bccdf2b9e906f.x958045f9b3dbfc27(xcf736b78463acc83 xb5d36a5b57626517)
at Aspose.Cells.ReportingServices.Renderer.x287918d12b9d430a(Report x64343a0786fb9a3f, NameValueCollection x4d7e972a483f38e6, NameValueCollection x769338e163ee6eb4, NameValueCollection x69ea43ef171861cd, Hashtable& xcc726f61cfb91835, CreateAndRegisterStream x6af66da7eca40f82)
at Aspose.Cells.ReportingServices.Renderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)
Worksheet names in this report are Summary,Detail, Ten,Fifteen, Twenty, so names are not duplicated. It looks like the problem is with page breaks in the report, I have page breaks after each tablix in order for Excel to create a separate worksheet per tablix. Other reports that I have in SSRS2008 and that do not have page breaks get exported fine using Aspose formats.
Is multiple worksheets report export supported in Aspose.Cells? Any suggestions on how to deal with this?