Icon

22_​XLS_​MultipleSheets

This example workflow is licensed under

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

Formatting different sheets explicitly XLS Sheet Selector defines the sheet that subsequent formatting instructions shall be applied to. Multiple sheets' formatting instructions are then combined via the XLSFormat Merger and finally written to the destination XLS file via XLS Formatter (apply) in one pass. This example workflow is licensed under the MIT License. SeeLICENSE.txt in the workflow directory for details.unformattedsheet salesinput tablecontrol tableunformattedsheet productinput tablecontrol tablethick borderaround everythingcombine instructionsfor both sheetsto oneapply all sheetformattings atoncefrom here on, direct allfurther formatting instructionsto sheet "sales"highlight Chinafrom here on, direct allfurther formatting instructionsto sheet "product"column Ato tag "data"column Bto tag "data"Excel Reader (XLS) XLS ControlTable Generator Excel Reader (XLS) XLS ControlTable Generator XLS BorderFormatter XLS Format Merger XLS Formatter(apply) XLS Sheet Selector XLS BackgroundColorizer XLS Sheet Selector ConstantValue Column ConstantValue Column Formatting different sheets explicitly XLS Sheet Selector defines the sheet that subsequent formatting instructions shall be applied to. Multiple sheets' formatting instructions are then combined via the XLSFormat Merger and finally written to the destination XLS file via XLS Formatter (apply) in one pass. This example workflow is licensed under the MIT License. SeeLICENSE.txt in the workflow directory for details.unformattedsheet salesinput tablecontrol tableunformattedsheet productinput tablecontrol tablethick borderaround everythingcombine instructionsfor both sheetsto oneapply all sheetformattings atoncefrom here on, direct allfurther formatting instructionsto sheet "sales"highlight Chinafrom here on, direct allfurther formatting instructionsto sheet "product"column Ato tag "data"column Bto tag "data"Excel Reader (XLS) XLS ControlTable Generator Excel Reader (XLS) XLS ControlTable Generator XLS BorderFormatter XLS Format Merger XLS Formatter(apply) XLS Sheet Selector XLS BackgroundColorizer XLS Sheet Selector ConstantValue Column ConstantValue Column

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-09-20
Last update: 2024-04-17
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!