Send To Excel: Should show hided fields as well

[mohan2391]

Hi Team,

I have a straight table, in that i have added 20 dimensions and 1 expression.

Out of those 20, i have selected only 7 dimensions as showed dimensions and have hided the rest 13 with the option available in presentation layer (below is the screenshot).

Now, the issue is:

when i click on "Send to Excel" (icon on chart - top right along with minimize,maximize), the excel is showing only the 7 dimensions and 1 expression, which i have made showed columns.

So, how to get the rest of the dimensions also in the excel..
Basically I want to show 7 dimensions & 1 expression in chart and want to see 20 dimensions and 1 expression in excel when they click on 'Send to Excel'

Is this possible, if yes, how ?

Thanks

[trdandamudi]

Please see the attached and hope this helps..

[simospa]

You could use a macro, if you are using this .qvw with IE plugin or via Local Client.

S.

[Anonymous]

Hi,

You must use a macro, with the send to Excel button you can only export what you show see on screen.

Kind regards

[mohan2391]

Hi Thirumala,

Thanks!!

How did you achieve this ?

I am seeing the hided column also in the excel..

Did you use macro for this or is this a built in feature ?

[Frank_Hartmann · Accepted solution]

see attached.

hope this helps