Converting XML to Excel creation through XSLT/Java Mapping

[Former Member]

Hi PI experts,

We have a requirement like IDOC to File Scenario. In this, we need to produce Excel sheet at the receiver end. For this i have used XSLT mapping. But here in the receiver communication channel/MM payload is showing correct data. whenever i am downloading payload & opening with Excel data is correctly opening. But when we are opening file in the target directory location XML data not showing completely that to when i am opening that file with  excel it is showing invalid data.

Could you please let me know your suggestions on this..

I have followed below procedure..

(or)

Could you please let me know any other alternative procedure.

Regards,

Srikanth Mavuri.

[iaki_vila · Accepted solution]

Hi Srikanth,

From my point of view the best to do it is at adapter level. Eng Swee Yeoh developed and shared an extraordinary converter that you can find here

Regards.

[Bhargavakrishna]

Hi Srikanth,

Please refer the below links

Excel conversion using Adapter module

SAPPITech - Blogs - Adapter Module to create Excel Output File

Regards

Bhargava Krishna