How to define columns for export to Excel in ALV table?

[former_member186148]

Hello SCN!

We have an ALV table in our WebDynpro for ABAP application. Some of table columns are invisible since users don't need to see them. But these columns need to be exported in Excel. As I know ALV exported in Excel only visible columns.

So my idea is follows:

- user choose "Export to Excel"

- application makes required columns visible

- export performs

- application makes these columns invisible.

The problem is I don't know where I should place the code performs bolded points.

Regards,

Lev

[nithinjabraham · Accepted solution]

Hi Lev,

You can create an additional custom button in the ALV tool bar and on action event you can write the code for downloading  and exporting the entire table to Excel.

Kindly refer the below link for downloading the internal table content to Excel in webdynpro.

http://scn.sap.com/docs/DOC-25024

Regards,

NJA