Problem using ALSM_EXCEL_TO_INTERNAL_TABLE function module

[Former Member]

Dear Experts,

I am trying to upload excel sheet to upload data into internal table,but the function module is giving out an error saying error in upload_OLE.This is working fine when upload data in my system but doesnt work when trying to upload in other system.

Let me know views on the same.

Thanks in advance.

Regards,

Kartheek.

[Former Member]

you can try to use following FM

PARAMETERS:    P_FILE LIKE RLGRAP-FILENAME DEFAULT 'C:\test.xls' OBLIGATORY.   

   CALL FUNCTION 'KD_GET_FILENAME_ON_F4'
 CHANGING
    file_name           = P_FILE.

[Former Member]

hi,

you may use function module "TEXT_CONVERT_XLS_TO_SAP'". Most simple to use without any complication. won't give any errror.

cheers.

Ankitesh

[Former Member]

The error might be due to type declaration of the input file path. Check for the type and try the FM CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'.

[Former Member]

Thanks to all replies.