Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
When using the 'Convert Excel to CSV' smart service in a process model, the node is failing when given an OOXML Excel file. It appears to be an issue with the Apache poi libraries not supporting OOXML files.
Is there any workaround to this? I've tried configuring the error output of the node to display an error message to the end user but it appears that the node fails before it can even write the error output. I also can't think of any way to check the file type in the process as the file extension of the OOXML Excel is identical to that of a regular Excel.