Removing Column from exported excel in ALV

[Former Member]

Hi,

I have displayed one ALV to user which displays first column for checkbox and second column for image.

When I export this ALV output to Excel using standard Export button, these two columns also get exported to Excel.

Is there a way by which I can remove these columns from exported excel.

Thanks,

Feroz

[Former Member · Accepted solution]

Check this thread []

Regards,

Radhika.

[Former Member · Accepted solution]

Hi Radhika,

Thanks for the reply, but I have already seen this link.

Actually I did not want to write custom coding thats why I used ALV.

If column configuration is not possible then may be I will have to write custom code for Export.

[Former Member]

Hi,

Please try this -

When you use the settings link to hide the columns, use it and hide the columns that you don't want to export, then try to Export. Check wether these hidden columns are also shown in the Excel.

Or

One more thing, In the EXPORT button functionality, try to get the column references of the table and hide those ccolumns programatically and try to export it.

While showing to user give these columns while export hide these columns by the above way.

One more thing, when you are using the standard EXPORT button, Your code doesnot trigger. Please check it.

I don't know wether this will be of any help. Give it a try.

Regards,

Lekha.

[Former Member]

Thank you Radhika and Lekha for the help.

I am Closing the thread could not do this.

Thanks,

Feroz