COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: BenziD on 14 Nov 2010 04:49:33 AM

Title: rename shet in multi sheet excel report
Post by: BenziD on 14 Nov 2010 04:49:33 AM
Hi
when I use 'page_set' to duplicate page by criteria and export to excel the sheets name are page1 ,page2 etc
I want to give the sheet name by the duplication criteria (country or language)

is it possible?
and how?
10X
Title: Re: rename shet in multi sheet excel report
Post by: g.congnos on 08 Jan 2014 03:14:31 AM
Hi
Have you solved it?

I have the same problem.

Thanks
Title: Re: rename shet in multi sheet excel report
Post by: msalice1 on 08 Jan 2014 11:30:55 AM
you have to create a macro to do that.. I would assume there would be a reference that you can reference within the sheet itself.. it would be something like this:

Sub sve()
For i = 1 To Sheets.Count
    Sheets(i).Name = Range("A" & i )
Next
End Sub