topic Re: Excel Data Upload into Internal Tables in Application Development and Automation Discussions

Excel Data Upload into Internal Tables

Former Member — Thu, 10 Aug 2006 08:42:47 GMT

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 ?

Re: Excel Data Upload into Internal Tables

Former Member — Thu, 10 Aug 2006 08:47:41 GMT

Hi,

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

Regards

vijay

Re: Excel Data Upload into Internal Tables

Former Member — Thu, 10 Aug 2006 08:47:42 GMT

Hi,

Did you try using 'ALSM_EXCEL_TO_INTERNAL_TABLE' function module?

Rgds,

Re: Excel Data Upload into Internal Tables

Former Member — Thu, 10 Aug 2006 08:49:15 GMT

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