Xml to PI to Excel File ?

[Former Member]

Hi experts,

i've been through some blogs but I do not find it, I only found for PDF Edition, but is it possible that PI creates an Excel file from an XML file ?

The flow would be : XML sent to PI, PI then creates an Excel file with a specific formal according to what has been sent and then send the file to a mailbox.

Is is possible ? If yes, do you have any idea how to ?

Thanks a lot for your help,

Jamal

[Former Member · Accepted solution]

Hi Jamal,

This can be achived in different ways as Java mapping / module etc..

Simple way is to create a java mapping which constructs Excel file as shown in the below link

https://wiki.sdn.sap.com/wiki/display/XI/CODE%20-%20Create%20an%20Excel%20File%20via%20the%20JExcel%...

Regards

Harsha Paruchuri

[Former Member]

Hi,

You need to build an scenario file(xml) to mail. You should use a javamapping Instead of a message mapping. Inside It you are going to read the xml(You can use dom) and generate the excel file(You can use POI Library).

Regards

Ivan

[Former Member]

hi

this blgo may help you

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

[Former Member]

Hi,

You can implement any of the below method.

/people/alexander.ong/blog/2009/03/30/how-to-handle-excel-documents-with-sap-pi

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

Inder