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
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

1 REPLY 1

matt
Active Contributor
0 Kudos

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.