topic Re: Excel Reading in Application Development and Automation Discussions

Excel Reading

Former Member — Fri, 14 Nov 2008 19:16:37 GMT

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

Re: Excel Reading

Former Member — Fri, 14 Nov 2008 19:30:29 GMT

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

Re: Excel Reading

Former Member — Fri, 14 Nov 2008 19:31:06 GMT

Hi,

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

Thanks

Naren

Re: Excel Reading

Former Member — Fri, 14 Nov 2008 20:03:22 GMT

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.