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: 

Upload XLSX with GUI_UPLOAD in a ECC6 7.00

ekekakos
Participant
0 Kudos
1,482

Is it possible to load in an itab an excel XLSX using the cl_gui_frontend_services=>gui_upload?

The system is ECC6 7.00 an old one so the new classes does not exists.
Thanks Elias
7 REPLIES 7

Sandra_Rossi
Active Contributor
0 Kudos
1,348

cl_gui_frontend_services=>gui_upload is a wrapper of function module GUI_UPLOAD.

ekekakos
Participant
0 Kudos
1,348

I think that the answer of an old link is true for the old systems.

Sandra_Rossi
Active Contributor
0 Kudos
1,348

I guess you mean this one answer:

LOL

I use GUI_UPLOAD all the time to upload .xlsx files, into internal table of bytes, and then I use abap2xlsx to get cell values from the internal table.

ekekakos
Participant
0 Kudos
1,348

Dear Sandra, you mean that in an ECC6/ SAP_BASIS/700/ 0031 you managed to load the ABAP2XLSX?

Please tell me how you did it. Thanks in advance

Sandra_Rossi
Active Contributor
1,348

You're right, you oriented your question to cl_gui_frontend_services, but your only question seems to be about reading XLSX file.

I remember that someone did a very light XLSX reader in this forum: Quick’n’dirty solution for parsing XLSX files on the go | SAP Blogs.

As you seem you want a solution running connected to SAP GUI, you could use the classic DOI solution based on OLE (slow but works when connected to SAP GUI).

ThorstenHoefer
Active Contributor

ekekakos
Participant
0 Kudos
1,348

Thanks ALL for your answers.