Download to excel from ALV
I am modifying the subtotals/totals in my ALV before display and refreshing the table.
Refresh the table display
CALL METHOD lo_grid->refresh_table_display
i_soft_refresh = 'X'.
Refresh the table
Call Method lo_grid->check_changed_data.
The output is indeed get modified and my new subtotals/totals are getting dispalyed, But when I use the Excel download button option from ALV-toolbar. I could only see my old data (previous subtotals/totals).
How can I get the modified subtotal/total in excel file.
P.S - Enduser will only use the excel button for download.