CODEWITHSUNDEEP
sqlexcelvisual-studio-2008
user2015159
user2015159

Reputation: 21

Renaming worksheets in Excel via export from Visual Studio 2010

I' m developing reports from Visual Studio 2010 using .rdlc extension.

There is a requirement where I have to export all reports to one excel file in the form of tabs.

When I export reports to Excel I can see the reports in the form of tabs(sheet1, sheet2, ........).

I want to rename these sheets. I have seen that in SQL Server 2008 R2 there is a property PageName which I' m unable to find in Visual Studio 2010. Please help me with this.

Upvotes: 2

Views: 2930

Answers (1)

bonCodigo
bonCodigo

Reputation: 14361

You can try this out:

PageName

Set this and then on export to excel the tab will use the page name. This can be set on certain objects in the report and can use Expressions to set the name. Objects that contain this property include:

 - Tablix
 - Rectangle

Here is the tutorial for you to explore:

Upvotes: 3

Related Questions