Generate output file with .xls or .xlsx in SAP CPI

[former_member277492]

Hello Experts,

I am working an Integration from SFEC to CPI, whereas Client's requirement is to generate the output file in Excel format (.xls or .xlsx) extension.

I have recommended .csv and that extension won't work for them.

Please could you help me out addressing this requirement.

Thank you,

Best Regards,

Sree

[akgfgn]

Hi Sreekar, We are working on a similar request. I hope you had made a successful conversion. Can you share us the solution approach you took to accomplish this?

[vadimklimov]

Hello Sree,

SAP CPI doesn't support operations with Microsoft Office document formats out of the box, so if you need to make conversion from/to Excel in CPI, you will have to build a custom-developed solution - most commonly, develop such conversion logic in a script using 3rd party libraries.

Good news is, there is an open-source development that engswee.yeoh shared with the community - FormatConversionBean, and it can be used to execute conversions between XML and various formats, Excel being one of them, so you might want to look into it. A CPI version of the module is described here - you can get detailed information about how to add the module to an iFlow, what dependencies it relies on and how the module can be configured in the mentioned blog post.

If that module will not fit your purpose, then you can develop your own conversion logic to Excel using a number of 3rd party libraries that are available for Java/Groovy - for example, Apache POI (which a FormatConversionBean uses, too).

Regards,

Vadim

[former_member277492]

Hello Vadim,

Thank you for the response.

I will go through the details shared by you and get back to you, In case of any further issues.

Thank you,

Best Regards,

Sree