topic Missing data when exporting ALV Report to Excel in Application Development and Automation Discussions

Missing data when exporting ALV Report to Excel

ricardo_fudaba — Fri, 19 Aug 2022 13:40:39 GMT

Hi members!

In an ALV Report data display good.

When I clicked right button on the grid, I choose “Spreadsheet” for downloading to Excel.

At Excel, no data displayed for various columns…

Otherwise, if I click on “Microsoft Excel (Ctrl+Shift+F7)”….

The behaviour is that the process spend more time than normal and is generated an Excel macro spreadsheet, with a lot of tabs, but all data is complete!

I do not want the Excel as a macro spreadsheet and more than one tab.

Please, can anyone help me on how to take the simple spreadsheet with all data?

I have been using Function ‘REUSE_ALV_GRID_DISPLAY’ to take the ALV report.

Best Regards,

Ricardo.

Re: Missing data when exporting ALV Report to Excel

ricardo_fudaba — Fri, 19 Aug 2022 17:43:10 GMT

Hi Members,

I solved the problem of missing data exporting ALV report to Excel.

The fieldname on fldcat-fieldname was wrote in lower-case.

After I change to upper-case, the data were exported Ok to Excel.

Best Regards,

Ricardo.

Re: Missing data when exporting ALV Report to Excel

custandcode — Thu, 09 Feb 2023 15:06:25 GMT

Hi,

To display Data in an ALV Grid I use the Method cl_salv_table=>factory.
In my opinion very easy to use and also with the Excel export you don't have these useless Excel tabs like "Sub1", "Sub2",...
regards

Re: Missing data when exporting ALV Report to Excel

RaymondGiuseppi — Thu, 09 Feb 2023 15:40:31 GMT

In these cases, always perform the consistency check on your Grid, ALV display is more error-tolerant than export.

Re: Missing data when exporting ALV Report to Excel

MarioMller — Thu, 22 Aug 2024 04:11:14 GMT

Hi,

I got a similar issue. Two columns with unneccessary ICON functionality where not exported to EXCEL.
After removing the ICON: SOLVED 🙂

     lr_column ?= lr_columns->get_column( 'ANLAGE' ).
      lr_column->set_cell_type( if_salv_c_cell_type=>hotspot ).
*      lr_column->set_icon( if_salv_c_bool_sap=>true ).
Regards Mario