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: 

Released FM/Method to upload Excel

bhaskar_nagula
Participant

‎01-11-2022 5:48 AM

Hi All,

Is there any released FM/Method to upload Excel from local PC to SAP?

Below following FMs are not released in status as these are not recommended to use in custom code by SAP.

  1. 'ALSM_EXCEL_TO_INTERNAL_TABLE' (clipboard error pop-up and also obsolete one)
  2. 'TEXT_CONVERT_XLS_TO_SAP' (won't work with decimal data type field in output table)
  3. 'SAP_CONVERT_TO_XLS_FORMAT'
  4. 'KCD_EXCEL_OLE_TO_INT_CONVERT'
  5. 'MS_EXCEL_OLE_STANDARD_DAT'

I have tried FM 'GUI_UPLOAD'(released in status) but this FM works only for .TXT format, not working for Excel formats i.e .XLSX, XLS, and .CSV.

5 REPLIES 5

FredericGirod
Active Contributor

‎01-11-2022 6:35 AM

ABAP2XLSX, you have to import it using ABAPGit

abo
Active Contributor

‎01-11-2022 8:48 AM

There a demo for reading files.

bhaskar_nagula
Participant

‎01-27-2022 9:51 AM

0 Kudos

Thanks for the comment but I was asking excel to internal table (Upload).

matt
Active Contributor

‎01-27-2022 5:08 PM

ABAP2XLSX

SamChung
Explorer

‎03-24-2023 8:26 AM

0 Kudos

Hi,

You may refer to the article as below.

https://www.samplecodeabap.com/how-to-upload-excel-to-sapusing-abap/