How to Read content of excel file cells.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-12-2024 12:07 AM
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
Labels:
- Labels:
-
Alfresco Process Services
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2024 12:19 PM
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
