Skip to Content
avatar image
Former Member

How do you upload an excel file into APO / SCM?

Hello

I am trying to write a program with functionality to upload an excel file format 'XLS' or 'XLSX' into an internal table in the APO / SCM environment.

Some of the standard Function modules either do not exist or do not work in the APO environment.

KCD_EXCEL_OLE_TO_INT_CONVERT does not exist in APO, while GUI_UPLOAD brings back only gibberish. The same with some classes.

I found this post which made use of XML transformations and classes,

https://www.sap.com/documents/2015/07/ced1ac7f-527c-0010-82c7-eda71af511fa.html#

but not all the classes such as

CL_XLSX_DOCUMENT exist yet in the version I am working in , i.e.

SAP Netweaver 7.0. They only exist from 7.02.

Does anyone know any way to upload an excel spreadsheet into an internal table in a normal SE38 program in this environment?

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 07, 2017 at 12:47 PM

    Since you are on an old version of ABAP, it will be quite difficult for you to achieve your requirement. Technically it's possible - but effectively you'll have to write your parser or use OLE.

    Simplest is to require the data as CSV. That's what was done until it became easy to handle XLSX directly.

    Add comment
    10|10000 characters needed characters exceeded