Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 13, 2017 at 12:59 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded