Mastering SAP ABAP

Saving a table to a Microsoft Excel file

The common business case for using OLE is to generate custom-format Excel files generated in an ABAP report. Please create a new ABAP program, ZMSA_R_CHAPTER4_6, and copy the report pattern from Appendix A, Assessments. If you checked the alms_excel_to_internal_table function module, you should know how OLE works. It's important to include just before our class definition OLE type information:

INCLUDE ole2incl.

We need to declare the following variables: 

DATA: lv_filename TYPE localfile VALUE 'c:\temp\testfile4_6.xls'.DATA: lo_excel TYPE ole2_object.DATA: lo_workbook TYPE ole2_object.DATA: lo_sheet TYPE ole2_object.                      DATA: lo_cell TYPE ole2_object.

For some systems, to make this example work ...