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.

Options

Applies to tag (single tag only)

Tag in your input table for which the formatting of this node should be applied to.

Enable mid scale point

Set this option if you want to create a three level coloring scheme.

Min

Set the lower bound for the coloring in the conditional formatter. The corresponding color will be displayed for all values smaller or equal than this threshold.

Min color

Choose a color in hex format with optional alpha channel.

Mid

Set the middle scaling point for the coloring in the conditional formatter.

Mid color

Choose a color in hex format with optional alpha channel.

Max

Set the upper bound for the coloring in the conditional formatter. The corresponding color will be displayed for all values greater or equal than this threshold.

Max color

Choose a color in hex format with optional alpha channel.

Views

This node has no views

Workflows

• 01_Correlation_MatrixKNIME Hub
• 07_XLS_ConditionalFormatterKNIME Hub
• 2nd Vernalis Benchmark example for Excel nodesKNIME Forum
• Continental Nodes ExampleKNIME Hub
• Demo XLS Control Table Auto Tag GeneratorKNIME Hub
• Show all 18 workflows

Links

• Formating Issueby izaychik63 on 2020-05-04

  forum.knime.com/p/89926

Developers