How to Read content of excel file cells.

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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