Skip to Content
avatar image
Former Member

How to process excel file in groovy script of HCI?

Dec 18, 2017 at 01:12 PM | 192 Views

Hi,

I have an incoming excel file from SFTP which I need to process in a groovy script but when I process the excel file in the groovy script it returns a corrupted excel file. How can I process an excel file in a groovy script.

Hope you can help.

Thank you.

SAP Cloud Platform Integration tools
SAP Cloud Platform | excel | sftp | groovy script
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Morten Wittrock
    Dec 18, 2017 at 11:40 PM

    Hi Donna

    You need something like the Apache POI library in order to process a binary Excel file in Cloud Integration. You can add the library's JAR file to your integration flow, and subsequently reference its classes from your Groovy script.

    Regards,

    Morten

    Add comment
    10|10000 characters needed characters exceeded