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: 

excel pop up during upload

rangerlet_mesee
Participant
0 Kudos
963

Hi

I am receiving the pop up preview of the excel which I try to upload via a Z program. One of the recommendations is macro compatibility settings in excel. But can this be avoided at SAP level?

May I know the reason and how to avoid the same?

4 REPLIES 4

raymond_giuseppi
Active Contributor
0 Kudos
775

Which tool do you use to upload Xlsx file, those pop-up are usually triggered by some OLE2 tool (so actually executing Excel, so depends on user settings)

Did you try to use a tool such as Abap2Xlsx or look in the forum for customer XLSX writer (xml/zip)

Sandra_Rossi
Active Contributor
0 Kudos
775

Uploading a file by Z program doesn't mean opening the Excel file.

Please explain how you then open the Excel file, and share the screenshot of Excel message and the exact message text.

NB: you're right that SAP can't do anything on Excel messages, except making sure that the right file extension is used with the Excel file format (e.g. .xlsx must be used for Office Open XML format, .csv must be used for comma-separated values, etc.) to avoid useless Excel messages.

rangerlet_mesee
Participant
0 Kudos
775

Actually, I am receiving the excel file preview with data(which I need to close later) while executing my custom program which later reads the file to an internal table. This did not happen in GUI 730 or lower.

Sandra_Rossi
Active Contributor
0 Kudos
775

I confirm that it's not a SAP problem.