EXCEL文件的import和export
1.从excel读入文件到ABAP PROGRAM
REPORT Z_TEST_MM03 .
DATA:BEGIN OF IEXCEL OCCURS 0.
INCLUDE STRUCTURE ALSMEX_TABLINE.
DATA:END OF IEXCEL.
PARAMETERS:FN1 LIKE RLGRAP-FILENAME MEMORY ID M01.
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
EXPORTING
FILENAME = FN1
I_BEGIN_COL = 1
I_BEGIN_ROW = 1
I_END_COL = 100
I_END_ROW = 1000
TABLES
INTERN = IEXCEL
EXCEPTIONS
INCONSISTENT_PARAMETERS = 1
UPLOAD_OLE = 2
OTHERS = 3.
IF SY-SUBRC <> 0.
WRITE:/ 'READ FLLE ERROR',FN1.
ELSE.
LOOP AT IEXCEL.
WRITE IEXCEL-VALUE(20).
AT END OF ROW.
WRITE: /.
ENDAT.
ENDLOOP.
ENDIF.