Skip to Content
0

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

Sep 13, 2017 at 11:52 AM

200

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Evgeniy Kolmakov Sep 13, 2017 at 12:59 PM
0

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-xml-easily/

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

https://poi.apache.org/

Regards, Evgeniy.

Share
10 |10000 characters needed characters left characters exceeded