Converting Excel data to XML for upload in XI

[Former Member]

Hey Guys!

I'm trying to convert a normal ms excel file containing data to an XML file format that may be used to upload information through XI. Has anyone done this before?

Thanks in advance!

Best Regards,

Glenn

[former_member91687 · Accepted solution]

Hi Glenn,

You have to use adapter modules for this purpose. Check this blog:

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

Use this pdf to help you with the adapter module configs.

<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/02706f11-0d01-0010-e5ae-ac25e74c4c81">How To create Modules for the J2EE adapter Engine</a>

Regards,

Chandra

[former_member206604 · Accepted solution]

Hi,

Check out my reply in this thread, that has adapter module code for reading Excel file

Also check this doc for writing Adapter modules

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3bdc14e1-0901-0010-b5a9-a01...

Thanks,

Prakash