Overview
Provides several smart services and functions for handling data in Excel and CSV formats.
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.