How to Read content of excel file cells.

[Lino17]

Hi,

I have a process which takes in an Excel file which has this info a list of IDNumbers in Row A from column 1 to column 5.

Now I want to get the IDNumber from all cells in the script task to do further work with it. So now how can I access the values of the IDNumber from the Excel Sheet

[openpj]

I would suggest to follow these steps in order to achieve your goal:

1. Use the APS SDK to correctly manage your Java extensions
2. Add the Apache POI Maven dependency in the extensions module
3. Implement a Custom Service Task using Apache POI in order to parse your Excel file

Hope this helps