Community
Application Development and Automation 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: 
Read only

How to import multiple Excel sheets into internal table

Former Member

‎2012 Dec 07 10:40 AM

0 Likes
412

Hi Experts,

I have an Excel file with 2 sheets(Sheet 1 & Sheet 2). how can i upload to these 2 sheets into data base table.

Can any one please tell me.

Hi Experts,

I have an Excel file with 2 sheets(Sheet 1 & Sheet 2). how can i upload to these 2 sheets into data base table.

Can any one please tell me.

Reply
1 REPLY 1
Read only

schneidertho
Product and Topic Expert
Product and Topic Expert

‎2012 Dec 07 8:14 PM

0 Likes
372

Hi Suman,

I have seen this working. But I have never implemented it myself (for example in SAP PPM). I think you can use OLE to communicate between SAP and Excel.

Found this discussion http://scn.sap.com/thread/1013189. Maybe it helps a bit (at least you can see which classes the mentioned function module uses internally).

Best regards

Thorsten