11-18-2011 10:17 AM
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.
11-19-2011 8:37 AM
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
11-19-2011 6:59 AM
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.
11-19-2011 8:37 AM
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
11-21-2011 6:15 AM
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'.
11-21-2011 9:48 AM