Issue with XLS Cell Updater Node

KNIME Analytics Platform
1

Hi,

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.

2

Hello @janf99 ,
Welcome to the KNIME Community!
Could you please share the workflow with dummy data(if confidential) so that we can try to reproduce the bug and share the log file so that we can understand this problem better?

Thanks,
Sanket

1 Like
3

Hi Sanket,

Thanks for your reply. I was able to resolve the issue. It seems to have been due to me having too many cell replacer nodes. I have now reduced the number to a minimum and simply added more inputs to have the same functionality.

2 Likes
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.