reading data from excel

[former_member532868]

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]

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]

Hi,

Check the following link:

http://sapdev.co.uk/file/file_upexcel.htm

Regards,

Bhaskar