how to upload exel file

[former_member424229]

Dear experts,

        I want to upload exel file and .csv into sap. For this i use the function module 'GUI_UPLOAD' and ' TEXT_CONVERT_XLS_TO_SAP'. In my abap they are working fine . When i add to portal it goes dump 'JAVA BEANS NOT SUPPORTED'. How to solve this.

Please help me.

Advance thanks.

[thanga_prakash]

This message was moderated.

[former_member76372]

use CL_GUI_FRONTEND_SERVICES=>GUI_UPLOAD instead.

[Former Member]

HI Krishna,

try using the following function modules to achieve uploading

'ALSM_EXCEL_TO_INTERNAL_TABLE'

and 'FILE_READ_AND_CONVERT_SAP_DATA' in se37.

or You can try to upload these files to Application Server and try using OPEN_DATASET therafter.

Hope it helps!!!!

Regards,

Alora

[Former Member]

Hi Krishna,

Refer to link