Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Excel data update in APO

former_member253525
Discoverer

‎2021 Feb 23 7:47 AM

0 Likes
1,220

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.

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.

Reply
2 REPLIES 2
Read only

abo
Active Contributor

‎2021 Feb 23 8:20 AM

0 Likes
1,141

You could try abap2xlsx

Read only

former_member253525
Discoverer

‎2021 Feb 27 8:53 PM

0 Likes
1,141

Hi All,

Got it resolve by using the class cl_gui_frontend_services.

Thanks
Arun