2022 Jan 18 7:14 AM - edited 2024 Feb 04 3:15 AM
Hi experts,
I have a requirement to upload excel file to SAP database. This excel file contains 8 fields and 999 rows. The 6th field may contain 1000+ characters.
I tried multiple FMs like GUI_UPLOAD, KCD_EXCEL_OLE_TO_INT_CONVERT, ALSM_EXCEL_TO_INTERNAL_TABLE custom configuration of ALSM_EXCEL_TO_INTERNAL_TABLE with value field of 1000 characters, nothing worked. Every time the database table's 6th field contains not more than 255 characters.
Please suggest solutions.
Thanks!
Request clarification before answering.
Seems like you could use abap2xlsx, the best kept secret in the whole abap developer community 😉
Specifically, you would want to start from ZDEMO_EXCEL15, which showcases the reader functionality.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
59 | |
10 | |
8 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.