Extracting data from XLS file using HCI DS

[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

[i827647]

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_INTEGR...

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

Best regards,

Edson Thomaz