'Assigning Field Symbols to Internal Table

I'm trying upload Excel file to internal table in ABAP. I'm using function GUI_UPLOAD and then SCMS_BINARY_TO_XSTRING. At last I have field sybmbol <gt_data> with data from Excel file.

DATA(lo_data_ref) = lo_excel_ref->if_fdt_doc_spreadsheet~get_itab_from_worksheet(
                                             lv_woksheetname ).
*-- Excel work sheet data in dyanmic internal table
    ASSIGN lo_data_ref->* TO <gt_data>.
A [CString] B [CString]
data1 data11
data2 data22
data3 data33

How I can iterate <gt_data> to internal table? I would try like below, but I received dump.

 TYPES: BEGIN OF lty_test,
           A  TYPE string,
           B TYPE string,
         END OF lty_test.

  DATA: lt_test_table    TYPE STANDARD TABLE OF lty_test.
abap


Solution 1:[1]

Try this:

    file = 'C:\xyz.XLS'.

  CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
    EXPORTING
      filename                = file
      i_begin_col             = '1'
      i_begin_row             = '1'
      i_end_col               = '5'
      i_end_row               = '6000'
    TABLES
      intern                  = xcel
    EXCEPTIONS
      inconsistent_parameters = 1
      upload_ole              = 2
      OTHERS                  = 3.

LOOP AT xcel.
  " xcel is an internal table and has field xcel-value
ENDLOOP.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions