Skip to Content
0
Former Member
Nov 21, 2008 at 09:18 AM

Load Excel

64 Views

Hi All

I Use this code

TYPES : BEGIN OF type_xldata,

string(800),

END OF type_xldata.

data: type_t_xldata TYPE STANDARD TABLE OF type_xldata.

CALL FUNCTION 'FAA_FILE_UPLOAD_EXCEL'

EXPORTING

i_filename = 'D:\2.xls'

I_DELIMITER = ';'

TABLES

et_filecontent = type_t_xldata

EXCEPTIONS

error_accessing_file = 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.

endif.

All work, but load string only 255 char . Need load maximum 800 char in row.

help please..

thx.