topic Re: Read EXCEL data into ABAP internal table in Application Development and Automation Discussions

Read EXCEL data into ABAP internal table

Former Member — Mon, 16 May 2011 15:34:18 GMT

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

Re: Read EXCEL data into ABAP internal table

Former Member — Mon, 16 May 2011 16:22:54 GMT

Did you try using a field symbol type any?

Re: Read EXCEL data into ABAP internal table

Former Member — Mon, 16 May 2011 16:25:51 GMT

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

......

Re: Read EXCEL data into ABAP internal table

koolspy_ultimate — Tue, 17 May 2011 03:59:37 GMT

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.