Skip to Content
0

Upload Excel with more then 10000 rows in to Internal Table in Background

Jan 05 at 12:31 PM

282

avatar image

Hi ,

I want to upload more than 10000 rows (it can be in lakhs) from excel into Internal table.But FM ALSM_EXCEL_TO_INTERNAL_TABLE has limitation of 9999.Please let me know how to do it.

Thanks

10 |10000 characters needed characters left characters exceeded

Not related to the question, but maybe it can interest you: to read XLSX format, prefer using abap2xlsx over ALSM_EXCEL_TO_INTERNAL_TABLE, because the latter is very slow and doesn't work in background. If the format can be different from XLSX, then OK for using ALSM_EXCEL_TO_INTERNAL_TABLE.

1
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Raymond Giuseppi
Jan 05 at 12:38 PM
2

Duplicate the FM into your namespace and adjust the code (good exercise to start with OLE2 in Abap)

Ref: 933420 - ALSM_EXCEL_TO_INTERNAL_TABLE

Share
10 |10000 characters needed characters left characters exceeded
Iftah Peretz
Jan 05 at 01:21 PM
1

If you choose not to use Raymond Giuseppi 's excellent suggestion,

you can break your input excel file into chunks of 9999 ( I don't think LOOPing over the size of the original input and setting the function parameters of I_BEGIN_ROW and I_END_ROW to those chunks accordingly will work, I'm not in front of an SAP system to check).

Or change the way you read data from Excel.

Share
10 |10000 characters needed characters left characters exceeded