on 10-10-2014 12:26 PM
Hi Experts,
I have implementing a scenario where requirements are Conversion of XML to EXCEL and EXCEL to XML.
how to do that?need xslt mapping ? or any adapter module is there in SAP?
please suggest any easy wayout ...
Thanks,
Arthita Banerjee.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arthita,
The link is working for me. Please find the link again
For Excel to XML conversion refer the below blog
SAPTechnical.COM - XI - Step-by-step guide to develop Adapter Module to read Excel file
XLS to XML conversion using JAVA Mapping in SAP XI 7.0 - Netweaver Technology - SCN Wiki
regards,
Harish
One of the ways might be to use an external service, like this Online Converter from XML to Excel to convert XML to Excel format.
It's an online converter and it is easy to use.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Actually you can create even java mapping very generic and use in one or multiple scenarios. we don't need to go for adapter module development. Pass input parameter as xml string and use apache poi or jexcel api.to convert xml strig to excel format.I'm sure you can also create UDF as function library and use the same across multiple scenarios. Please search jexcel api or apache poi and download and try.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arthita,
My few cents. To chose one or another solution suggested by Harish you should consider if you will have more further scenarios. For only one scenario or two take the XSL/Java mapping way. If you will more scenarios the best option is the Adapter Module way for its re-usability.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.