upload_ole error

[Former Member]

Hi,

I am using the fm ALSM_EXCEL_TO_INTERNAL_TABLE to upload the excel file into an Internal table. Its working fine but some times it is throwing an error UPLOAD_OLE error.

Can somebody has an idea on this?

Thanks

bpr

[Former Member]

Use Fm like This:

call function 'ALSM_EXCEL_TO_INTERNAL_TABLE'
exporting
filename = filename
i_begin_col = 5
i_begin_row = 2
i_end_col = 6
i_end_row = 4000
tables
intern = t_excel
exceptions"Handle all exceptions(This is must).
inconsistent_parameters = 1
upload_ole = 2
others = 3.

[Former Member]

Thanks all. Solved myself

[Former Member]

Hi,

How did you solve?

[former_member617554]

Check the state of EXCEL.

[matt]

Use ABAP2XLSX.