Skip to Content
avatar image
Former Member

How to process excel file in groovy script of HCI?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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