topic Re: excel upload in string table in Application Development and Automation Discussions

excel upload in string table

Former Member — Wed, 04 Jun 2008 11:35:58 GMT

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.

Former Member — Wed, 04 Jun 2008 11:38:39 GMT

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

Former Member — Wed, 04 Jun 2008 12:38:50 GMT

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