I am experiencing an issue with the cell updater node. I have prepared a file with several tables and sheets that I have prepared. I have gotten my workflow to generate the required input lists (first column with references and second column with string or number fields). Several of these nodes are used to populate the different tables. I have observed the following behaviour:
List item For some tables the cells are correctly updated.
List item For a few tables the cells are not updated and there is no warning or error (sometimes resetting and executing the node will fix this).
List item Sometimes the node will give an error such as “ERROR Excel Cell Updater 0:306 Execute failed: Truncated ZIP file” or "ERROR Excel Cell Updater 0:328 Execute failed: org.apache.xmlbeans.XmlException: error: Element type “c” must be followed by either attribute specifications, “>” or “/>”. Then, when rerunning the node works fine.
Has anyone observed this kind of issue/behaviour and knows a potential solution? I have retried the same with a completely unformatted xlsx and xls file, but the issue remains.