Icon

10_​XLS_​SheetProperties

This example workflow is licensed under

This example workflow is licensed under
the MIT License. See LICENSE.txt in the
workflow directory for details.

Option 1: Freeze Sheet at Cell Option 3: Hide Rows/Columns Option 2: Create table with filters Apply Formatting Instructions to XLS File After having collected all formatting instructionsfrom the XLS Formatter nodes, apply these toyour XLS file. Hide rows/columns that have a tagged cell. Define a filter for a given tag range. Freeze the sheet at a specific cell. E.g. freeze at cell A2 tokeep the first row when scrolling down. This example workflow is licensed under the MIT License. SeeLICENSE.txt in the workflow directory for details.A2freezefreeze sheetat tag freezeD1hidehide columnsat tag hideA1:G20datafilter tablefor range dataXLS Formatter(apply) XLS Control Tablefrom Cell Range XLS SheetProperties XLS Control Tablefrom Cell Range XLS SheetProperties XLS Control Tablefrom Cell Range XLS SheetProperties Option 1: Freeze Sheet at Cell Option 3: Hide Rows/Columns Option 2: Create table with filters Apply Formatting Instructions to XLS File After having collected all formatting instructionsfrom the XLS Formatter nodes, apply these toyour XLS file. Hide rows/columns that have a tagged cell. Define a filter for a given tag range. Freeze the sheet at a specific cell. E.g. freeze at cell A2 tokeep the first row when scrolling down. This example workflow is licensed under the MIT License. SeeLICENSE.txt in the workflow directory for details.A2freezefreeze sheetat tag freezeD1hidehide columnsat tag hideA1:G20datafilter tablefor range dataXLS Formatter(apply) XLS Control Tablefrom Cell Range XLS SheetProperties XLS Control Tablefrom Cell Range XLS SheetProperties XLS Control Tablefrom Cell Range XLS SheetProperties

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: user
Created at: 2019-03-12
On NodePit since: 2019-07-12
Last update: 2024-04-18
Created with KNIME version: v4.0.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!