topic How to Read content of excel file cells. in Alfresco Forum

How to Read content of excel file cells.

Lino17 — Fri, 12 Jan 2024 05:07:02 GMT

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

Re: How to Read content of excel file cells.

openpj — Wed, 24 Jan 2024 17:19:16 GMT

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

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

Hope this helps