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

(or)

Could you please let me know any other alternative procedure.

Regards,

Srikanth Mavuri.

replied

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

Regards.

0 View this answer in context

Helpful Answer

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