Excel sheet uploading problem

Former Member — Fri, 03 Jul 2009 15:40:49 GMT

Hi Experts,

How to upload excel sheet into sap, what is the function module to be used.

Thanks and Regards,

Thirukumaran. R

Moderator message - Please search before asking - post locked

Edited by: Rob Burbank on Jul 3, 2009 11:58 AM

Re: Excel sheet uploading problem

Former Member — Fri, 03 Jul 2009 15:58:54 GMT

Hi,

Please use the below function module

-- To Convert Excel file to Internal table.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_TAB_RAW_DATA = TAB_RAW_DATA

I_FILENAME = P_FNAME

TABLES

I_TAB_CONVERTED_DATA = GT_XLDATA1

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2.

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ELSE.