downloading hidden column in to excel in ALV

[Former Member]

In the alv catalogue,i have a particular column set

to NO_OUT = 'X'.when i download the gird contents to excel

i want the hidden fields to be downloaded,is there a way of downloading hidden feilds.

[ssimsekler]

Hi Kaushik

Just a work-around.

At the event <b>"before_user_command"</b>, use the method <b>"set_frontend_fieldcatalog"</b> to set the <b>"no_out"</b> option for those fields to space.

At the event <b>"after_user_command"</b>, use the same method again to restore normal settings.

And let us know whether this helped...

*--Serdar

[Former Member]

Hey Serdar,

That is a neat trick. Hope that does the job. And Kaushik don't forget to say <b>Thanks the SDN way</b>(Click on the yellow star and award suitable points).

Regards,

Subramanian V.

[Former Member]

Dear Serdar,

Thankyou for your reply,could you please give me a code sample.

kind regards

kaushik hegde

[Former Member]

Kaushik,

Are you using, REUSE_ALV_GRID_DISPLAY or OO approach ?

Regards,

Subramanian V.

[ssimsekler]

Hi Kaushik

You can find relevant information at the tutorial <a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/documents/a1-8-4/an%20easy%20reference%20for%20alv%20grid%20control.pdf">"An Easy Reference for ALV Grid Control"</a>. Inspect sections on "Building Blocks" and "Event-Based Functionalities".

*--Serdar