Upload XLSX with GUI_UPLOAD in a ECC6 7.00

[ekekakos]

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

[Sandra_Rossi]

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

[ekekakos]

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

[Sandra_Rossi]

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]

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]

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]

Please check

Excel XLSX Upload – Unified approach for different ABAP Versions | SAP Blogs

[ekekakos]

Thanks ALL for your answers.