Skip to Content
avatar image
Former Member

How to convert .XLS file from SFTP server to XML in SAP HCI

Hi Experts,

I have a requirement in which Customers are placing excel file(.XLS) on SFTP server and HCI needs to pick the file and post the entry in S4H.

I see we have standard functions to convert .CSV to XML or vice versa.

How shall I achieve the requirement. Please suggest

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 17 at 09:32 AM

    Hello Preeti,

    There is no standard way to convert XLS to XML in SAP CPI.You need to write a script to convert the same using any open source library or below might help you.

    https://gist.github.com/madan712/3912272

    Regards,

    Sriprasad Shivaram Bhat

    Add comment
    10|10000 characters needed characters exceeded