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

  1. Go to item

Related workflows & nodes

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

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