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
Showing results for 
Search instead for 
Did you mean: 

Upload an excel file with multiple worksheet

colin_cheong
Contributor
0 Kudos
398

Hi All SAP Guru,

I need to upload multiple worksheet from an excel file into SAP temp tables for processing.

Is there any standard FM that I can used?

Is there any standard SAP program that does that?

I am in rel 4.7

please assist.

2 REPLIES 2

Former Member
0 Kudos
39

HI,

Check out this link for a sample code.

http://diocio.wordpress.com/2007/02/12/sap-multiple-sheet-excel-document/

and also refer this blog,

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

hope this helps u

Regards,

sathiya Ramasmay

Former Member
0 Kudos
39

Hi colin,

Refer the following sdn forum link... The code does exactly what u need...

Use it...

Regards,

Naveenan.