Excel Reading

[Former Member]

Hi ,

I had read excel using CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP' .But we got to read from second record as first is header display.

Some parametes we can set .

Ivneet

[Former Member]

Hi Ivneet,

Once you fetch the data from the excel sheet by using CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP' .

After that you can delete the first record from the internal table.

This way it will work.

Thanks,

Chidanand

[Former Member]

Hi,

Pass I_LINE_HEADER = 'X' to the function module..

Thanks

Naren

[Former Member]

Hi ivneet,

We use:

  CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
       EXPORTING
            FILENAME    = D_FILE1
            I_BEGIN_COL = 1          " first column
            I_BEGIN_ROW = F_ROW          " first row
            I_END_COL   = 1          " last column
            I_END_ROW   = L_ROW          " last row
       TABLES
            INTERN      = ITAB.

And I just have the user enter the first/last row on the selection screen, or hard code it.

Good luck.

SL