How to retrieve data from Excel?

[Former Member]

Hi,

How would I use XI inorder to crete an interface to Excel?

Thanks,

M

[Former Member]

Hey "Mushon"...

Working fridays ha?

Another way is :

instead of saving the file as a regular excel file you can ask your customer to save it as a csv file.

This will enable you to use the file with conversion and not need for java programming.

Have a nice weekend.

Nimrod

[MichalKrawczyk]

Hi Mushon,

there are three ways:

1. create a jave proxy:

Read Excel instead of XML through FileAdapter

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

2. use the conversion agent (without java programming)

/people/paul.medaille/blog/2005/11/17/more-on-the-sap-conversion-agent-by-itemfield

3. you can also create your own excel adapter

Regards,

michal