Skip to Content
author's profile photo Former Member
Former Member

Header line in Gui_upload

Hello,

I wish to upload contents of an excel file to an internal table using GUI_UPLOAD.

This file has the first row as header for the rows below.

How do i ignore this row when uploading contents to internal table?

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jun 02, 2007 at 07:40 AM

    Welcome to SDN.

    IF you want it to upload with GUI_UPLOAD then after uploading the records in table delete the row with index 1 from the intenal table.

    otherwise you can always go for ALSM_EXCEL_TO_INTERNAL_TABLE, where you can give the sarting row and column to read the excel.

    I will prefer the later one anytime over the former.

    A sample code -

    CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

    EXPORTING

    filename = filename

    i_begin_col = begcol

    i_begin_row = begrow

    i_end_col = endcol

    i_end_row = endrow

    TABLES

    intern = intern

    EXCEPTIONS

    inconsistent_parameters = 1

    upload_ole = 2

    OTHERS = 3.

    IF sy-subrc <> 0.

    WRITE:/ 'Upload Error ', SY-SUBRC.

    ENDIF.

    clear intern.

    LOOP AT intern.

    at new col.

    v_new = 1.

    endat.

    if v_new = 1.

    clear v_new.

    col = intern-col.

    CASE col .

    when '1'.

    itab-ENO = intern-value.

    when '2'.

    itab-ENAME = intern-value.

    endcase.

    endif.

    at end of row.

    append itab. clear itab.

    endat.

    endloop.

    Regards,

    Amit

    Reward all helpful replies.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.