Upload EXCEL XLS

*&---------------------------------------------------------------------*
*&      Form  UPLOAD_XLS
*&---------------------------------------------------------------------*
*       Hochladen XLS
*----------------------------------------------------------------------*
*  -->  p1        text
*  <--  p2        text
*----------------------------------------------------------------------*
FORM upload_xls .

DATA:    ls_raw_data TYPE truxs_t_text_data,
         ls_data TYPE gty_data,
         lt_data TYPE TABLE OF gty_data.

  "Lade das XLS File in die Tabelle GT_DATA
  CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
    EXPORTING
      i_line_header        = 'X'
      i_tab_raw_data       = ls_raw_data
      i_filename           = pa_file
    TABLES
      i_tab_converted_data = lt_data[] " Data
    EXCEPTIONS
      conversion_failed    = 1
      OTHERS               = 2.
  IF sy-subrc <> 0.
    MESSAGE E002(ZPOUP).
  ENDIF."

ENDFORM.                    " UPLOAD_XLS

Funktionsbausteine für andere Formate

TEXT_CONVERT_CSV_TO_SAP

TEXT_CONVERT_TEX_TO_SAP

TEXT_CONVERT_TXT_TO_SAP

TEXT_CONVERT_XML_TO_SAP

Sowie:

SAP_CONVERT_TO_CSV_FORMAT

SAP_CONVERT_TO_TEX_FORMAT

SAP_CONVERT_TO_TXT_FORMAT

SAP_CONVERT_TO_XLS_FORMAT

SAP_CONVERT_TO_XML_FORMAT