Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Reading Excel file with multiple worksheets

Former Member

‎05-06-2007 5:53 PM

0 Kudos

Hi,

I have a requirement to use a excel sheet with multiple worksheets.

I have looked as several blogs..

I have tried this....

/people/sap.user72/blog/2006/01/19/upload-data-from-multiple-worksheets-within-a-single-excel-file-into-internal-table-from-abap

but couldnt really suceed..

I have gone through this also..

It says

"Used OLE to upload the excel spread sheet with multiple worksheets to upload"

But no narration how to use..

Can anyone help me on this

Regards,

Krishna

1 REPLY 1

Former Member

‎05-12-2007 9:25 PM

0 Kudos

See this site: AN EASY REFERENCE FOR OLE AUTOMATION by Serder Simsekler.

Best!

Jim