cancel
Showing results for 
Search instead for 
Did you mean: 

How to Read content of excel file cells.

Lino17
Champ in-the-making
Champ in-the-making

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

1 REPLY 1

openpj
Elite Collaborator
Elite Collaborator

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 Smiley Wink