cancel
Showing results for 
Search instead for 
Did you mean: 

Excel File Upload with 8 fields and 999 rows, 6th field with 1000+ characters

former_member769799
Discoverer
0 Kudos
394

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!

Accepted Solutions (0)

Answers (1)

Answers (1)

abo
Active Contributor
0 Kudos

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.