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