DATA: itab_htkp TYPE TABLE OF alsmex_tabline WITH HEADER LINE,
    l_tabix_htkp TYPE i.

    • 将数据转化到内表中
      CALL FUNCTION ‘ALSM_EXCEL_TO_INTERNAL_TABLE’
      EXPORTING
      filename = p_htkp
      i_begin_col = 1
      i_begin_row = 2
      i_end_col = 13
      i_end_row = 99999
      TABLES
      intern = itab_htkp[]
      EXCEPTIONS
      inconsistent_parameters = 1
      upload_ole = 2
      OTHERS = 3.
      SORT itab_htkp BY row col.
      LOOP AT itab_htkp.
      l_tabix_htkp = itab_htkp-col.
      ASSIGN COMPONENT l_tabix_htkp OF STRUCTURE wa_htkp TO .
      = itab_htkp-value.
      AT END OF row.

      1. REPLACE ALL OCCURRENCES OF ',' IN wa_tab-kbetr_c WITH ''.
      2. APPEND wa_htkp TO it_htkp.
      3. CLEAR:wa_htkp.


    ENDAT.
    ENDLOOP.