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..
Could you please let me know any other alternative procedure.
Iñaki Vila replied
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