ABAP 读取EXCEL 文件内容,函数 TEXT_CONVERT_XLS_TO_SAP

EXCEL 内容:

读取内容:

代码:

TYPES: BEGIN OF ITAB,
      FL1(50)  TYPE C,
      FL2(50)  TYPE C,
      FL3(50)  TYPE C,
      FL4(50)  TYPE C,
      FL5(50)  TYPE C,
      FL6(50)  TYPE C,
END OF ITAB.
DATA: T_ITEM TYPE TABLE OF ITAB WITH HEADER LINE.

TYPES TRUXS_T_TEXT_DATA(4096) TYPE C OCCURS 0.
DATA: IL_RAW TYPE TRUXS_T_TEXT_DATA,P_LOAD LIKE RLGRAP-FILENAME .

P_LOAD = 'C:\XXX\TEST.xlsx'.
CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
  EXPORTING
*   I_FIELD_SEPERATOR          = 分隔符，默认为Tab
*