cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping / Uploading MS Excel file data to SAP system using XI

Former Member
0 Kudos

Hi Everybody,

I need help regarding mapping / uploading of MS Excel data which will be available in a sheet to an application in R/3 system. This has to be accomplished using XI.

Attributes that are in the excel file "Time Sheet" are as follows..

a)Name & other employee details

b)Time Sheet for the month

c)Date

d)Project & Location

e)Description

f)Activity Type

g)No of hours

h)Remarks

please guide me how to accomplish this.

Thanks & Regards

K.Ramesh

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Ramesh,

yes check the blog provided by Shesagiri..

Here u have to use adapter modules for reading the excel file...

see here some useful links for adpater module...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/02706f11-0d01-0010-e5ae-ac25e74c...

http://help.sap.com/saphelp_nw04/helpdata/en/8b/895e407aa4c44ce10000000a1550b0/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/12/f9bb2fe604a94cbcb4c50dc510b799/content.htm

/people/michal.krawczyk2/blog/2006/10/09/xi-dynamic-configuration-in-adapter-modules--one-step-further

/people/gowtham.kuchipudi2/blog/2006/01/04/testing-sample-adapter

/people/john.ta2/blog/2006/12/20/to-create-or-not-to-create-an-sap-xi-adapter

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/02706f11-0d01-0010-e5ae-ac2...

[original link is broken]

/people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter

/people/sap.user72/blog/2005/07/15/copy-a-file-with-same-filename-using-xi

PPT: https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e21106cc-0c01-0010-db95-dbfc0ffd...

How to Guide: https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f013e82c-e56e-2910-c3ae-c602a67b...

Regards

Biplab

Former Member
0 Kudos

Have you checked these links??

/people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter

/people/michal.krawczyk2/blog/2005/12/10/xi-generating-excel-files-without-the-java-nor-the-conversion-agent-not-possible

Former Member
0 Kudos

Thanks but he has given solutuin for generating excel files using XI, but i want it the other way round -- Read from Excel files and upload to SAP system.

Former Member
0 Kudos

Hi,

Check the Blog provided by me,

There explained abt How to read the Excel file data using File Adapter

Regards

Seshagiri

Former Member
0 Kudos

Hi,

Read Excel instead of XML through FileAdapter

/people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter

Regards

Seshagiri