ABAP2XLSX and alv based CL_SALV_TABLE with alv layout

Hello sap experts,

we are about to use abap2xlsx and try to create an include with different output option.

One option should be that an alv (based on CL_SALV_TABLE) and its layout should be converted to xlsx. That xlsx can than be send to direct display, frontend, backend or via email.

For me it looks like the conversion of the alv is only possible in background mode. Otherwise I get a dump because method GET_METADATA of CL_SALV_TABLE is called in method ZCL_EXCEL_WORKSHEET=>BIND_ALV... where I create the xlsx worksheet based on the alv.

Therefore I have this code.

So is there a possibility to have the alv output somehow hidden in online mode? Or are there any alternative solutions? I think it would be possible (but not user friendly) that the user displays the alv and goes back. Afterwards the xlsx object is created and processed.

Thank you in advance.

Best Regards

Thomas