Skip to Content
0

Extracting data from XLS file using HCI DS

Aug 29, 2017 at 10:09 AM

78

avatar image
Former Member

Hi Experts,

Please suggest, is it possible to extract data from XLS file in HCI DS. If yes, then how do we achieve that.

Many Thanks,

Lisin

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

1 Answer

avatar image
Former Member
Sep 20, 2017 at 07:16 PM
0

Hi Lisin

The HCI-DS can read and write delimited files (eg .CSV) and XML files, as mentioned on PAM - page 9:

https://support.sap.com/content/dam/launchpad/en_us/pam/pam-essentials/TIP/PAM_SAP_HANA_CLOUD_INTEGRATION_DS.pdf

You could export the XLS file to a CSV and read it.

Best regards,

Edson Thomaz

Share
10 |10000 characters needed characters left characters exceeded