ALV Excel Export : where does the magic happen?

[daniel_humberg]

I like the built-in excel export of the ALV a lot.

I need to develop an export into a customer-specific format, and I could not really find the place where the ALV determines the data that is it currently showing (considering all the special features like sorting, filtering, cell variants, conversion exits, dropdowns, etc.). Any idea?

[Former Member]

Checkout the code exchange projects

[https://cw.sdn.sap.com/cw/groups/abap2xlsx|https://cw.sdn.sap.com/cw/groups/abap2xlsx]

[Former Member]

Hi Daniel,

Were you able to figure out where the magic happens? I do know that the event handlers for ALV standard functions ON_STD_FUNCTION_BEFO or ON_STD_FUNCTION_AFTE are the available hooks. I still however have not been able to gather how I could tweak just the data that is used to generate the Excel.

I believe one option would be to hide the standard button altogether and create a custom button for the export.

Thanks,

Puja