issue with cl_gui_frontend_services=>gui_upload

[pashasapcha]

Hi, gurus,

I am looking to upload data from excel sheet to internal table.

I changed excel file to csv file with comma delimiter.

I have called cl_gui_frontend_services=>gui_upload method , the following is the code below.

The problem is the data is getting moved in first column only as shown in the pic .

the below is the declaration part where I made p_fname as string.

[RaymondGiuseppi]

In the FM signature the parameter HAS_FIELD_SEPARATOR is described as 'Columns Separated by Tabs in Case of ASCII Upload' - So don't handle the CSV separator as ';' or ','

You could

• Split the data yourself in a loop
• Use a standard CSV tool

[pashasapcha]

Can I use GUI_UPLOAD method to get excel xsls data into internal table for this ?

[RaymondGiuseppi]

The GUI_UPLOAD doesn't (yet) handle the zipped/xml format of XLSX

• Look at this online help page Excel with SAP - An overview (shortcut) - From Microsoft OLE to ABAP2XLSX.
• You should notice that SAP classified Method CL_GUI_FRONTEND_SERVICES=>GUI_UPLOAD as Obsolete tools...