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: 

how to upload the data from excel(3 tabs) file to sap environment

Former Member

‎2006 Apr 09 8:59 AM

0 Kudos
742

Hi all,

This is Mahesh.

how to upload the data from excel(3 tabs) file to sap environment (internal tables) while doing bdc.

2 REPLIES 2

guillaume-hrc
Active Contributor

‎2006 Apr 09 10:15 AM

0 Kudos
99

Hi,

The FM 'ALSM_EXCEL_TO_INTERNAL_TABLE' makes it possible to load a worksheet into an internal table in ABAP.

However, if you want to get the data from several worksheets, I think you are stuck with OLE access to your Excel Workbook...

You can find a solution for 2 worksheets in this post :

I think you can easily modify it to handle any number of worksheets.

Hope it helps !

Best regards,

Guillaume

athavanraja
Active Contributor
In response to guillaume-hrc

‎2006 Apr 09 11:50 AM

0 Kudos
99

check out this weblog

<a href="/people/sap.user72/blog/2006/01/19/upload-data-from-multiple-worksheets-within-a-single-excel-file-into-internal-table-from-abap">Upload data from Multiple Worksheets within a single Excel File into internal table from ABAP</a>

Regards

Raja