12-07-2017 12:11 PM
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.
12-07-2017 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.