Excel Data Upload into Internal Tables

[Former Member]

I have an excel workbook with 2 worksheets in them.

I need to upload each of these worksheets in 2 different internal tables.

How can i achieve this ?

[Former Member]

I have an excel workbook with 2 worksheets in them.

I need to upload each of these worksheets in 2 different internal tables.

How can i achieve this ?

[Former Member]

Hi,

Check this thread .in this you can see the solution.

Regards

vijay

[Former Member]

Hi,

Did you try using 'ALSM_EXCEL_TO_INTERNAL_TABLE' function module?

Rgds,

HR

[Former Member]

Hi,

use FM <b>ALSM_EXCEL_TO_INTERNAL_TABLE</b> or <b>GUI_UPLOAD</b> fm..

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

FILENAME = P_PFILE

I_BEGIN_COL = 1

I_BEGIN_ROW = 1

I_END_COL = 2

I_END_ROW = 3000

TABLES

INTERN = IT_EXCEL

* EXCEPTIONS

* INCONSISTENT_PARAMETERS = 1

* UPLOAD_OLE = 2

* OTHERS = 3

Check this thread ..

Regards,

Santosh

Message was edited by: Santosh Kumar P