Microsoft Excel 

To generate an Excel list from the ALV output, the user simply chooses the corresponding pushbutton from the toolbar. The user cannot affect the result in advance.

However, in your application, you can define whether information other than the ALV output is also copied to the Excel file when the user triggers the export. This applies to:

·        Design objects for header and footer areas

·        Result rows for calculations

Copying Design Objects to the Excel File

If you have defined a design object for a header or footer for the ALV output, you can define whether the content of this design object should also be copied into the Excel file. You use the methods of the interface class IF_SALV_WD_EXPORT_SETTINGS for this (implementing class CL_SALV_WD_CONFIG_TABLE).

Methods for Copying Design Objects into the Excel File

Function	Method
Copy design object for the Excel header	SET_EXPORT_NO_TOL
Check whether the design object is to be copied for the Excel header	GET_EXPORT_NO_TOL
Copy design object for the Excel footer	SET_EXPORT_NO_EOL
Check whether the design object is to be copied for the Excel footer	GET_EXPORT_NO_EOL

Copy Result Rows for Calculations into the Excel File

You can define whether result rows containing the results or interim results of aggregations should be copied to Microsoft Excel when the export takes place. You use the methods of the interface class IF_SALV_WD_EXPORT_SETTINGS for this (implementing class CL_SALV_WD_CONFIG_TABLE).

Methods for Copying Result Rows into the Excel File

Function	Method
Copy result rows to Excel	SET_EXPORT_NO_SUMS
Check whether result rows are copied to Excel	GET_EXPORT_NO_SUMS