File to File (with XLS input)

[Former Member]

Hi all,

I want to try the File to File scenario with input file as Excel sheet (.xls), not CSV. Can I proceed as normal File to File with FCC? If so, tell me what is the delimiter.

Or, Is there any special way of handling this case? Please suggest me.

Regards

krishna.

[Former Member · Accepted solution]

Hi Krishna,

It will not be achieved with FCC. To convert XLS to XML you have to write a Module and use it in File adapter. Refer this blog

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

Thanks

Farooq.

[aashish_sinha]

Hi,

I guess you can convert the data into a xml using the xls file only. there is a way in excel to convert data to xml and then you can use it as ur xml input to xi or may be you can convert that data to csv and use it in xi.and then handle it as normal file

This link will be helpful if u want it using xls only.

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

Hope this will help you a bit.

regards

Aashish Sinha

PS : reward points if helpful

[Former Member]

Hi Krishna,

Please see this, if this can help you more :-

https://websmp206.sap-ag.de/~sapidp/011000358700000600992007E

https://www.sdn.sap.com/irj/sdn/xi?rid=/webcontent/uuid/a680445e-0501-0010-1c94-a8c4a60619f8 [original link is broken]

See if this weblog helps

/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions

http://www.sap.com/france/services/education/newsevents/cert-xi-dev.epx

/thread/25311 [original link is broken]

Vishal

• Reward points for useful Help

[Former Member]

HI,

Go through the below weblog:

Read Excel instead of XML through FileAdapter

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

Thnx

Chirag