Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • XLS Conditional Formatter
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:

  1. Go to item

Related workflows & nodes

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

No known nodes available

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits