How to Write XML in Microsoft excel (.xls , xlsx) in SAP PI

[Former Member]

Hi Experts,

We have a Proxy to Excel file Interface. We are using SFTP adapter at receiver end. I"ve used module configuration to get excel file in .csv format. But we require file in .xls or .xlsx format. Could you please help us ? We are currently using 7.31 version dual stack.

[former_member190293]

Hi Venu!

First way is to use custom adapter module:

https://blogs.sap.com/2014/10/21/exceltransformbean-part-1-convert-various-excel-formats-to-simple-x...

The second way is to use java mapping and external libraries for working with Office documents:

https://poi.apache.org/

Regards, Evgeniy.