Free Support Forum - aspose.com

Rename Excel Worksheets in SSRS 2005

hi

can you rename tabs in excel out of SSRS 2005?


This message was posted using Aspose.Live 2 Forum

Hi,<?xml:namespace prefix = u1 />

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

We are not very clear about your requirement. Please provide us further details regarding it. Also, when you use Aspose.Cells.ReportingServices to render report, worksheet name is automatically set as per the report name. Also, we support Documents Map function.

Please read Aspose.Cells for Reporting Services document for more details regarding Aspose.Cells for Reporting Services.

Thank You & Best Regards,

in SSRS 2005, you can export to excel with multiple “sheets/tabs”, but not name them. they default to Sheet1, Sheet2, etc.

using your custom SSRS extension, can you rename the tabs?

cj

and i want to do this dynamically - based on a result set from the database

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Currently, we only support to change sheet name as per following conditions.

1. RDL format define is SSRS 2005 format define.

2. Group tag as paging.

3. Sheet name is group tag value.

4. Modify the value of page sheet name at Aspose.Cells.ReportingServices.xml

========================

<Page>

<SheetName value="group"/>

</Page>

========================

Please check it and see if it fits your requirements.

Thank You & Best Regards,

in all due respect, i dont understand what you said.
can someone contact me or provide a link with an example

c

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

We will get back to you soon regarding your query.

Thank You & Best Regards,

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

<?xml:namespace prefix = u1 />Please install SQL Server 2005 Sample and find Product Catalog.rdl file in ${SQL Server 2005Installation folder}/90/samples/Reporting Services/Report Samples/ Adventure Works sample reports folder. Use VS2005 to open Adventure Works sample reports.sln and publish to your reporting services server. Render product catalog report and check exported XLS file.

Install Aspose.Cells for Reporting Services. Modify the value of page sheet name at Aspose.Cells.ReportingServices.xml

========================

========================

Render product catalog report and check exported XLSX file. Also, please check the attached files of product catalog for reference. The worksheet name of Product Catalog.xls file is different from the worksheet name of Product Catalog.xlsx file.

Thank You & Best Regards,

in all due respect, this is nothing like the feature i was promised.

please email me directly

i want this feature, in SSRS 2005

cj

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Well, the solution I mentioned in my previous post is the solution to re-name the worksheet using Aspose.Cells for Reporting Services. I am afraid; this is the only way to rename the worksheet available at the moment with Aspose.Cells for Reporting Service. If you know any work around using SSRS, please share with us the process and we will check if that can be implemented using Aspose.Cells for Reporting Services too.

Thank You & Best Regards,