Excel data update in APO

former_member253525 — Tue, 23 Feb 2021 07:47:40 GMT

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.

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

Thank you.

Re: Excel data update in APO

abo — Tue, 23 Feb 2021 08:20:44 GMT

You could try abap2xlsx

former_member253525 — Sat, 27 Feb 2021 20:53:10 GMT

Hi All,

Got it resolve by using the class cl_gui_frontend_services.

Thanks
Arun