Hub
NodeNode / Manipulator

XLS Sheet Properties

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

The XLS Sheet Properties node changes sheet properties, such as freeze, auto-filter, hidden columns, or hidden rows.

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 Sheet Properties node is part of this extension:

Related workflows & nodes

  1. 10_XLS_SheetProperties
    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 > 10_XLS_SheetProperties
    Continental_KNIME_Extension_Developer
  2. 07 - freeze the first row and autosize
    kowisoft > Public > Continental XLS Formatter Tutorial > 07 - freeze the first row and autosize
    kowisoft
  3. 08 - apply formats
    kowisoft > Public > Continental XLS Formatter Tutorial > 08 - apply formats
    kowisoft
  4. 99 - final workflow
    kowisoft > Public > Continental XLS Formatter Tutorial > 99 - final workflow
    kowisoft
  5. Excel Formatter - Excelの装飾
    Japanese 日本語 Makkynm
    +13
    Excel FormatterのNode紹介用Workflowです。 InputファイルはInputフォルダからダウンロードしてください。 これらのNodeを使うには拡張機能のイ…
    makkynm > Public > Intermediate > I211_Excel_Formatter
    makkynm
  6. 02_Pretty_Table
    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 > 02_Pretty_Table
    Continental_KNIME_Extension_Developer
  7. 02_Pretty_Table
    This example workflow is licensed under the MIT License. See LICENSE.txt in the workflow …
    bdu > Public > 02_Pretty_Table
    bdu
  8. Continental Nodes Example
    tosinlitics > Public > Continental Nodes Example
    tosinlitics
  9. 23_XLS_MultipleSheetsViaLoop
    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 > 23_XLS_MultipleSheetsViaLoop
    knime
  10. 03_Logistics
    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 > 03_Logistics
    Continental_KNIME_Extension_Developer