Hub
NodeNode / Manipulator

XLS Conditional Formatter

Community Nodes Continental XLS Formatter Formatter
Drag & drop
Like
Copy short link

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.

Node details

Input ports
  1. Type: Table
    Control Table
    XLS Control Table holding tags that define which cells of the sheet to format.
  2. Type: XLS Formatter
    Optional 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
    XLS Formatter
    The XLS Formatter output port holding the collected formatting instructions including the added formatting information from this node.

Extension

The XLS Conditional Formatter node is part of this extension:

Related workflows & nodes

  1. 07_XLS_ConditionalFormatter
    This example workflow is licensed under the MIT License. See LICENSE.txt in the workflow …
    knime > Examples > 99_Community > 05_Continental_Nodes_for_KNIME > 02_XLS_Formatter > 01_Tutorials > 07_XLS_ConditionalFormatter
    Continental_KNIME_Extension_Developer
  2. Excel Formatting
    Life Sciences Excel Format
    +3
    If you would like to format your Excel File, you can use the Community Extension: Contine…
    knime > Workflow Snippets > Excel Formatting
    knime
  3. Flow Variable As Output Filename for XLS Formatter
    Flow Variable Excel Writer Path
    +3
    Demonstration of creating a "relative path" in a String flow variable without using the k…
    takbb > Public > FlowVariableAsOutputFilenameXLSFormatter
    takbb
  4. Excel Formatter - Excelの装飾
    Japanese 日本語 Makkynm
    +13
    Excel FormatterのNode紹介用Workflowです。 InputファイルはInputフォルダからダウンロードしてください。 これらのNodeを使うには拡張機能のイ…
    makkynm > Public > Intermediate > I211_Excel_Formatter
    makkynm
  5. Continental Nodes Example
    tosinlitics > Public > Continental Nodes Example
    tosinlitics
  6. Flow Variable As Output Filename for XLS Formatter (Simplified)
    Flow Variable Excel Writer Path
    +3
    Demonstration of creating a "relative path" in a String flow variable without using the k…
    takbb > Public > FlowVariableAsOutputFilenameXLSFormatter Simplified
    takbb
  7. Demo XLS Control Table Auto Tag Generator
    Continental XLSX Formatting
    Workflow to demonstrate using Continental XLS formatting nodes to format two separate she…
    takbb > Public > Demo Workflows > ComponentDemo > Demo XLS Control Table Auto Tag Generator
    takbb
  8. 01_Correlation_Matrix
    This example workflow is licensed under the MIT License. See LICENSE.txt in the workflow …
    knime > Examples > 99_Community > 05_Continental_Nodes_for_KNIME > 02_XLS_Formatter > 02_Applications > 01_Correlation_Matrix
    Continental_KNIME_Extension_Developer