Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Transfer Excel file to internal table

Hi Experts,

I have one question to you. What i need -> open excel file and put content of it to internal table. I'm using for that

CALL METHOD cl_gui_frontend_services=>gui_upload

    EXPORTING

      filename = lv_fname <- path to file

     filetype = 'ASC'

    CHANGING

      data_tab = istr[].

At the end i can see, that istr[] has a content, but it is unreadible and looks like:

###-W###Ail###EZ#V###>⟂Q#exa##|I#########GH2'##6##§݊#rnT##N#'#

Could you please help me to solve this issue?

Please notice, that in EWM system i can't use FM such as

TEXT_CONVERT_XLS_TO_SAP,

ALSM_EXCEL_TO_INTERNAL_TABLE.

Thank you very much for help

Former Member
Not what you were looking for? View more on this topic or Ask a question