EXCEL to internal table Function Module for large amounts of data

[former_member727610]

I'm looking for a function module that supports large amounts of data. My excel file can consist of up to 15000 records that i want uploaded into an internal table that i will work later with. The only FM i am aware of is 'ALSM_EXCEL_TO_INTERNAL_TABLE', but with that i am able to import up to 100 records at a time, only. Alternatively, i could call it in a loop maybe to fill out my whole table multiple times, but is there another FM i could use?

[former_member727610]

I'm looking for a function module that supports large amounts of data. My excel file can consist of up to 15000 records that i want uploaded into an internal table that i will work later with. The only FM i am aware of is 'ALSM_EXCEL_TO_INTERNAL_TABLE', but with that i am able to import up to 100 records at a time, only. Alternatively, i could call it in a loop maybe to fill out my whole table multiple times, but is there another FM i could use?

[Sandra_Rossi]

Use abap2xlsx to generate your professional Excel spreadsheets from ABAP.

[MateuszAdamus]

Hello underfree22

There is an ABAP2XLSX library which I strongly recommend. You can get it from here: https://github.com/sapmentors/abap2xlsx

And here is an article about reading large Excel files: https://blogs.sap.com/2014/01/27/a-way-of-reading-huge-excel-files/

Kind regards,
Mateusz

[Patrick_vN]

What Sandra said, though recently I saw a construction where they saved the XLS as XML and then uploaded the XML and used STRANS to convert it to an internal table. I didn't try, but the developer claimed that it was more performant for "laaarge" XLS files.

[Sandra_Rossi]

Precision: I meant "generate and read", abap2xlsx works in both directions.