Released FM/Method to upload Excel

[Former Member]

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.

[Former Member]

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.

[FredericGirod]

ABAP2XLSX, you have to import it using ABAPGit

[abo]

There a demo for reading files.

[Former Member]

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

[matt]

ABAP2XLSX

[SamChung]

Hi,

You may refer to the article as below.

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