XLS Conditional Formatter


The XLS Conditional Formatter node defines instruction for your spreadsheet application to color cell backgrounds according to their numeric value.

This node defines a formatting instruction only which needs to be written to an xlsx file via the XLS Formatter (apply) node subsequently.

Input Ports

  1. Type: Data
    XLS Control Table holding tags that define which cells of the sheet to format.
  2. Type: XLS Formatter
    The XLS Formatter input port potentially holding previous formatting instructions that the instructions of this node shall be added to.

Output Ports

  1. Type: XLS Formatter
    The XLS Formatter output port holding the collected formatting instructions including the added formatting information from this node.


This node is part of the extension

Continental Nodes for KNIME


Short Link

Drag node into KNIME Analytics Platform