Excel file to XML file

[Former Member]

Hi Expets!

I have a requirement to convert Excel file to XML file. This is new to me . When i serach in SDN i came to know that we want to create an EJB Module. I am not having much knowledge in Java bean. we are using the PI7.1 version.

I need to know what is the basic requirements for creating this EJB Module and also some inputs for how to start with this scenario.

Thanks and Regard's

Preethi.

[Former Member]

hi,

Is it an excel file or CSV file opening in MS Excel. Try opening the same file in notepad.

regards, Ani

[Former Member]

u have to create a adapter module for the same...

/people/shabarish.vijayakumar/blog/2009/04/05/excel-files--how-to-handle-them-in-sap-xipi-the-alternatives

http://wiki.sdn.sap.com/wiki/display/ABAP/AdapterModuleToReadExcelFilewithMultipleRowsandMultiple+Columns

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

Libraries for adapter module development:

http://wiki.sdn.sap.com/wiki/display/XI/Where%20to%20get%20the%20libraries%20for%20XI%20development

how to create adapter module in PI7.1:

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/c0b39e65-981e-2b10-1c9c-fc3f8e6747fa

[Former Member]

hi!

Thanks for your quick reply. i will try it out.

Regard's

Preethi.