topic Re: How to down load data from excel sheet into ABAP Program? in Application Development and Automation Discussions

How to down load data from excel sheet into ABAP Program?

Former Member — Wed, 15 Nov 2006 06:54:48 GMT

Can you provide any FM for this?

Re: How to down load data from excel sheet into ABAP Program?

Former Member — Wed, 15 Nov 2006 06:58:01 GMT

ALSM_excel_to_interal_table.

bye

murthy

Re: How to down load data from excel sheet into ABAP Program?

gopi_narendra — Wed, 15 Nov 2006 06:59:23 GMT

ALSM_EXCEL_TO_INTERNAL_TABLE and SAP_CONVERT_TO_XLS_FORMAT

Regards

- Gopi

Re: How to down load data from excel sheet into ABAP Program?

Simha_ — Wed, 15 Nov 2006 06:59:54 GMT

Hi,

Use the F.M <b>GUI_UPLOAD</b> by saving excel as tab limited file...

Cheers,

SImha.

Re: How to down load data from excel sheet into ABAP Program?

Former Member — Wed, 15 Nov 2006 07:07:41 GMT

Use FM ALSM_EXCEL_TO_INTERNAL_TABLE

TYPES:

BEGIN OF ty_upload,

field1 TYPE c length 12,

field2 TYPE c length 12,

field3 TYPE c length 12,

END OF ty_upload.

DATA it_upload TYPE STANDARD TABLE OF ty_upload WITH DEFAULT KEY.

DATA wa_upload TYPE ty_upload.

DATA itab TYPE STANDARD TABLE OF alsmex_tabline WITH DEFAULT KEY.

FIELD-SYMBOLS: <wa> type alsmex_tabline.

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = filename

i_begin_col = 1

i_begin_row = 1

i_end_col = 3

i_end_row = 65535

TABLES

intern = itab.

LOOP AT itab ASSIGNING <wa>.

CASE <wa>-col.

WHEN '0001'.

wa_upload-field1 = <wa>-value.

WHEN '0002'.

wa_upload-field2 = <wa>-value.

WHEN '0003'.

wa_upload-field3 = <wa>-value.

ENDCASE.

APPEND wa_upload TO it_upload.

CLEAR wa_upload.

ENDLOOP.

Best Regards,

Vibha

*Please mark all the helpful answers

Re: How to down load data from excel sheet into ABAP Program?

Former Member — Wed, 15 Nov 2006 07:17:44 GMT

Hi ,

U can also use

1.ALSM_EXCEL_TO_INTERNAL_TABLE

2. 'KCD_EXCEL_OLE_TO_INT_CONVERT' FM

to upload data from excel into internal table.

1. CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = filename

i_begin_col = 1

i_begin_row = 1

i_end_col = 3

i_end_row = 65535

TABLES

intern = it_vbak.

2. DATA : l_intern TYPE kcde_cells OCCURS 0 WITH HEADER LINE.

DATA : l_index TYPE i.

DATA : l_start_col TYPE i VALUE '1',

l_start_row TYPE i VALUE '1',

l_end_col TYPE i VALUE '256',

l_end_row TYPE i VALUE '65536'.

CALL FUNCTION 'KCD_EXCEL_OLE_TO_INT_CONVERT'

EXPORTING

filename = p_file

i_begin_col = l_start_col

i_begin_row = l_start_row

i_end_col = l_end_col

i_end_row = l_end_row

TABLES

intern = l_intern

EXCEPTIONS

inconsistent_parameters = 1

upload_ole = 2

OTHERS = 3.