05-16-2011 4:34 PM
Hi All,
I appreciate your help on the below please;
I need to Read EXCEL data into ABAP internal table when the excel cell length is extendedly large like 2000 characters (reading SAP long text);
please let me know a function module for the above purpose if you know;
thank you vewry much
Iver
05-16-2011 5:22 PM
05-16-2011 5:22 PM
05-16-2011 5:25 PM
Please try using field symbol as internal table as follows,
field-symbols: <fs_outtab> type table.
call function 'GUI_DOWNLOAD'
exporting
filename = l_guifilename
tables
data_tab = <fs_outtab>
exceptions
......
05-17-2011 4:59 AM
hi use this fm
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
EXPORTING
FILENAME = <FILENAMe>
I_BEGIN_COL = 1<user defined>
I_BEGIN_ROW = 2<user defined>
I_END_COL = 3<user defined>
I_END_ROW = 5000<user defined>
TABLES
INTERN = xl_itab.
* EXCEPTIONS
* INCONSISTENT_PARAMETERS = 1
* UPLOAD_OLE = 2
* OTHERS = 3 .
IF SY-SUBRC = 0.
* MESSAGE 'DATA UPLOADED SUCCESSFULLY' TYPE 'I'.
ENDIF.