Skip to Content
avatar image
Former Member

Extracting data from XLS file using HCI DS

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    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

    Add comment
    10|10000 characters needed characters exceeded