Skip to Content
0

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

Jan 17 at 09:02 AM

92

avatar image
Former Member

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

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

1 Answer

Sriprasad Shivaram Bhat
Jan 17 at 09:32 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded