How to Download/Upload data form multiple sheets Excel file??

Hi Everyone,

I am using a ECC 6.0 system, and I need to download routing data to Excel file( which should have two sheets to display routing header and operation data ) for users to view, and if they made any change to the routing data in the Excel, I must update it into SAP.

The question is, I don't have much exp on developing ABAP programs with Excel, so I am not sure which technique fits this requirement best, DOI? OLE? or just call some FM?

Any suggestion would be highly appreciated. If possible pls show me some sample codes or links... 😊

Thx,

Richard