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: 

Uploading EXCEL with multiple sheets in abap.

prav_kr
Participant

‎06-13-2012 11:41 AM

0 Kudos

  IS OLE the only way to upload an excel sheet with multiple workbook (all in different formats) in abap CRM or ABAP-HCM ?? 

OR

some function module is available.

Moderator message: frequently discussed, please do more research before posting.

Message was edited by: Thomas Zloch

4 REPLIES 4

Former Member

‎06-13-2012 11:49 AM

0 Kudos

Hi Prav,

Ole will be the best option to upload excel sheet........

Regards,

Ashwath.

Former Member

‎06-13-2012 11:56 AM

Hi,

Please see the below attached code to upload data from multiple sheets.

Its bit simple than ole.

Hope its helpful.

Regards,

Rajesh

Excel Upload.txt.zip

venkateswaran_k
Active Contributor

‎06-13-2012 11:59 AM

0 Kudos

Hi

Refer to following link..  http://scn.sap.com/thread/594226

REgards,

Venkat

former_member213851
Active Contributor

‎06-13-2012 12:21 PM

0 Kudos

Hi Prav,

With OLE you can have various other options for Excel such as Font ,color, spacing etc.

So take Exel with nultiple workbooks and add data in it with varios Font/ color and then Convert it to XML file.

Now use this XML code and replace hardcoded values with Workarea fields inside LOOP-ENDLOOP.

Best Regards,

Sachin