renaming excel sheets

Question

Post reply

renaming excel sheets

newbie_new

SSC Enthusiast

Points: 162
More actions
August 7, 2009 at 1:52 pm

#208364

Does anyone know of any code that will rename the worksheets in the excel export from SSRS?
I have multiple worksheets and would like to give them custom names to match the report.
:crazy:

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Chirag Prajapati SSC Eights! Points: 904 More actions · Answer 1

Hi,

Can you elaborate the issue ?

what are the steps you are following or the sample RDL File which is exported as Excel ?

Thanks

newbie_new SSC Enthusiast Points: 162 More actions · Answer 2

I just want to give each worksheet tab a name other than Sheet1, Sheet2, Sheet3.

Ron McCullough SSC Guru Points: 63877 More actions · Answer 3

Read this article

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

Scroll down the page unitl you reach *OLE Automation it will show you what I think you need to do.

By the way the article will allow you to download all the code discussed / listed in the article's text

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

newbie_new SSC Enthusiast Points: 162 More actions · Answer 4

Bitbucket:

Thanks for you assist, but i think i'm looking for something that deals directly with exporting in the excel format from SSRS 2005. When ever i export a report that has multiple sheets, i always get sheet1, sheet2, sheet3, etc. I'm trying to get these sheet names to come out as a customized name.

Chirag Prajapati SSC Eights! Points: 904 More actions · Answer 5

It looks like Microsoft.ReportingServices.ExcelRendering.dll

is taking care of exporting the data to excel.

I was not able to find any config file if it takes any name from that.

At this point of time I think it is limitation of SSRS to give the sheet name if more than two sheets are there.

While in case of single sheet it takes the name of Report as sheet Name.

chris duffield SSC Journeyman Points: 97 More actions · Answer 6

This link shows how to use xml / xlst to rename the sheets.

http://spacefold.com/lisa/post/Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT.aspx