Print Page - Dynamic naming of Excel work sheet Sheet tab

Title: Dynamic naming of Excel work sheet Sheet tab
Post by: kalyan_sekhar1 on 07 Jan 2007 08:16:21 AM

Hi All,

I am running a report in the Excel in which the different lists placed in the report will be stored in different work sheet tabs in the same excel file

The work sheet tab name is always the page name which is defined. LEts say for e.g if Page Name is "Scorecard" then the work sheet tab names as "Scorecard-1", "Scorecard-2"...

Rather then having a staic name, i want to have a dynamic name lets say if there is a Query item "Scorecard Name", can i assign this? so that i can populate the work sheet names dynamically

Thanks

Title: Re: Dynamic naming of Excel work sheet Sheet tab
Post by: gops210 on 23 Feb 2007 09:00:17 AM

Hi Kalyan,
Im facing the similar requirement,could u please share ur suggestions if u got the solution.

Thanks in advance

Title: Re: Dynamic naming of Excel work sheet Sheet tab
Post by: AnthonyJ on 21 Sep 2010 12:40:05 PM

Any luck with this ? Are you able to achieve dynamic sheet names in Excel simply by using an item's LOV ?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: kalyan_sekhar1 on 07 Jan 2007 08:16:21 AM