topic Re: reading data from excel in Application Development and Automation Discussions

reading data from excel

former_member532868 — Tue, 20 May 2008 13:12:17 GMT

how can i get data from excel to my internal table for decimal 5

data type.very very urgent for me.Please do the needful.

my error is field type defining as a decimal 5.refering built in table field type.

Regards,

hari

Former Member — Tue, 20 May 2008 13:22:36 GMT

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = w_file_name

i_begin_col = 1

i_begin_row = 1

i_end_col = 1

i_end_row = 2000

tables

intern = i_excel

EXCEPTIONS

INCONSISTENT_PARAMETERS = 1

UPLOAD_OLE = 2

OTHERS = 3.

IF sy-subrc eq 0.

MOVE : c_i TO s_refnr-sign ,

c_eq TO s_refnr-option.

clear e_excel.

loop at i_excel into e_excel.

move e_excel-VALUE TO t_refnr-low.

APPEND t_refnr.

endloop.

Former Member — Wed, 21 May 2008 06:32:18 GMT

Hi,

Check the following link:

Regards,

Bhaskar