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
  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
  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
  4. Excel Formatter - Excelの装飾
    Japanese 日本語 Makkynm
    +13
    Excel FormatterのNode紹介用Workflowです。 InputファイルはInputフォルダからダウンロードしてください。 これらのNodeを使うには拡張機能のイ…
    makkynm > Public > Intermediate > I211_Excel_Formatter
  5. Continental Nodes Example
    tosinlitics > Public > Continental Nodes Example
  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
  7. 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