XLS Conditional Formatter

Manipulator

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.

Find here

Community Nodes > Continental > XLS Formatter > Formatter

Make sure to have this extension installed:

Continental Nodes for KNIME

Update site for KNIME Analytics Platform 3.7:
Stable Community Contributions

How to add and enable update sites

How to install extensions