Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Read Excel to itab with more than 50 chars per cell

luis_rod
Participant

‎2023 Jul 10 8:50 PM

0 Kudos
363

Hi all:


I am trying to read an Excel file using the FM FILE_READ_AND_CONVERT_SAP_DATA . Nevertheless, all the cells with long texts get truncated to 128 characters.

I ended up creating a copy of the FM ALSM_EXCEL_TO_INTERNAL_TABLE, changing the structure in order to accept longer columns. Nevertheless, this seems to me, as a solution, a little kludgy. Isn't there a more elegant solution?

Any ideas?

TIA,

Luis

2 REPLIES 2

Sandra_Rossi
Active Contributor

‎2023 Jul 11 6:08 AM

269

ALSM_EXCEL_TO_INTERNAL_TABLE is not released by SAP, has many drawbacks. How to read Excel files has been already answered in the forum (may depend on format, CSV, XLSX, XMLSS, etc.): abap2xlsx, XCO, blog posts, etc.

luis_rod
Participant

‎2023 Jul 11 12:54 PM

0 Kudos
269

Sandra,

Thanks for your post. Precisely, searching the forum is where I found the idea about creating my own version of ALSM_EXCEL_TO_INTERNAL_TABLE. I did not know it had not been released by SAP. In this particular case, .CSV wasn't an option (that one for sure it would been a lot easier). Had thought about ABAP2XLSX, but for time constraints, such as having it approved and so on, it wasn't and option either.

Thanks again for your help.

Regards,

Luis