Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Converting XML to Excel creation through XSLT/Java Mapping

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..

Convert incoming XML to Excel or Excel XML – Part 1 - XSLT Way


Could you please let me know any other alternative procedure.


Srikanth Mavuri.


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 ExcelTransformBean Part 2: Convert simple XML to various Excel formats easily


0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question