Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Read EXCEL data into ABAP internal table

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Did you try using a field symbol type any?

3 REPLIES 3

Former Member
0 Kudos

Did you try using a field symbol type any?

0 Kudos

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

......

koolspy_ultimate
Active Contributor
0 Kudos

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.