Export data from ALV to Excel using class ALV2XLSX

With class ALV2XLSX, you can export data from ALV grids, internal tables to excel files with a simple method, main features of class:

• Export data from ALV grid (cl_gui_alv_grid) to excel file with full ALV characteristic such as:

- ALV list header

- ALV filters

- ALV sort criterion

- ALV dependent fields: currency, quantity

- ALV subtotal/total lines

- And other ALV fieldcat charateristic

• Export internal table to excel file with input SLIS/LVC field catalogs, sort criterion, filters ... like ALV grid.

• Insert blank rows, write cells/work area/internal table ... to excel file.

OVERVIEW:

• From ALV:
  
  
  
  
• To Excel:
  
  
  

DOWNLOAD INSTALLATION AND DEMOS:

• Installation: NUGG_ALV2XLSX-0.1.1.nugg (using SAPLINK to install)
• Class user guide: User_guide.pdf
• Demos:

Demo 1: Export data from ALV grid object to excel:
- Program source code: NUGG_ZCL_ALV2XLSX_DEMO1.nugg

- Exported excel file: ZCL_ALV2XLSX_DEMO1.xlsx

Demo 2: Export internal table to excel with full ALV characteristic:
- Program source code: NUGG_ZCL_ALV2XLSX_DEMO2.nugg

- Exported excel file: ZCL_ALV2XLSX_DEMO2.xlsx

Demo 3: Other features: Insert blank rows, write cells/work area/internal table ... to excel:
- Program source code: NUGG_ZCL_ALV2XLSX_DEMO3.nugg

- Exported excel file: ZCL_ALV2XLSX_DEMO3.xlsx

Class ALV2XLSX now is integrated in project ABAP2XLSX :

https://cw.sdn.sap.com/cw/groups/abap2xlsx