import data into internal table from excel file with extension .XLSX

[former_member185116]

Hello all,

i am importing data from excel to internal table using

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

according to the definition of FM itself , it is accepting files with extension .XLS,

my question is is there any FM by which we can import data from files with extension .XLSX,

thanks in advance..

[Sandra_Rossi]

Search for the free tool "abap2xlsx". Demo programs are also provided.

Edit: its advantage compared to OLE or DOI programs (like SAP ECC only function modules ALSM_EXCEL_TO_INTERNAL_TABLE, KCD_EXCEL_OLE_TO_INT_CONVERT, TEXT_CONVERT_XLS_TO_SAP, etc.) is that abap2xlsx can run in background, is much faster, and is available in all ABAP-based systems (by installing it). abap2xlsx operates directly on the XLSX format.

[Former Member]

I've used ALSM_EXCEL_TO_INTERNAL_TABLE successfully with .xlsx files.

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = l_filename

i_begin_col = 1

i_begin_row = 2

i_end_col = 19

i_end_row = 65535

TABLES

intern = lt_excel

EXCEPTIONS

inconsistent_parameters = 1

upload_ole = 2

OTHERS = 3.

[Former Member]

FM TEXT_CONVERT_XLS_TO_SAP CAN IMPORT XLSX TO Internal Table. We used it to import xls/xlsx in our project.

[Former Member]

Function module KCD_EXCEL_OLE_TO_INT_CONVERT converts xlsx file to internal table