05-23-2022 10:46 AM
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>.<br>
| 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.
05-23-2022 11:04 AM
Sigh, why so much pain? 😄
Have you considered abap2xlsx? There'a demo for loading files
05-23-2022 11:06 AM
05-23-2022 12:25 PM
What is the rest of your code? Is it what you're looking for?
FIELD-SYMBOLS <gt_data> TYPE STANDARD TABLE OF lty_test.
LOOP AT <gt_data> ASSIGNING FIELD-SYMBOL(<line>).
ENDLOOP.