Skip to Content
0

How to process excel file in groovy script of HCI?

Dec 18, 2017 at 01:12 PM

125

avatar image
Former Member

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
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
avatar image
Morten Wittrock Answered Dec 18, 2017 at 11:40 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users