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
Showing results for 
Search instead for 
Did you mean: 
Read only

excel upload in string table

Former Member
0 Likes
542

i'm trying to upload excel data into a string table .

i have tried cl_gui_frontend_services=>gui_upload

and FM gui_upload.

but both are giving string file with special charcters in my internal table .how to do please help.

2 REPLIES 2
Read only

Former Member
0 Likes
431

Hello,

Use the code page parameter for the GUI_DOWNLOAD FM .

Pass the value as '4103'

or one more option is:

Use the FM 'SAP_CONVERT_TO_XLS_FORMAT'.

Regards,

Deepu.K

Read only

Former Member
0 Likes
431

SAVE AS that excel file as TXT format.

Then use it as file type 'DAT' in gui_upload.

It will defiantly work.

Hope it will help you.

Regards,

Swarup