Icon

09_​Multiple_​Sheet_​in_​one_​Excel_​File

Write three files in one Excel file on three sheets
Create flow variable (category name) in Row Filterand use it as sheet name Manually input name of sheet for each category This workflow separates values in different sheets according to the marital status of the person. There are three different ways to fulfill this result. Loop over the marital-status category and write each part into a separate sheet Read adult dataDivorcedNever-marriedSeparatedSeparatedNever-marriedDivorcedIterate throughmarital-status instancesclose loop"Divorced" sheet"Never-married" sheet"Separated" sheet"Divorced" sheet"Never-married" sheet"Separated" sheetBased on current Iteration File Reader Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Group Loop Start Variable Loop End Excel SheetAppender (XLS) Excel SheetAppender (XLS) Excel SheetAppender (XLS) Excel SheetAppender (XLS) Excel SheetAppender (XLS) Excel SheetAppender (XLS) Excel SheetAppender (XLS) Create flow variable (category name) in Row Filterand use it as sheet name Manually input name of sheet for each category This workflow separates values in different sheets according to the marital status of the person. There are three different ways to fulfill this result. Loop over the marital-status category and write each part into a separate sheet Read adult dataDivorcedNever-marriedSeparatedSeparatedNever-marriedDivorcedIterate throughmarital-status instancesclose loop"Divorced" sheet"Never-married" sheet"Separated" sheet"Divorced" sheet"Never-married" sheet"Separated" sheetBased on current IterationFile Reader Row Filter Row Filter Row Filter Row Filter Row Filter Row Filter Group Loop Start Variable Loop End Excel SheetAppender (XLS) Excel SheetAppender (XLS) Excel SheetAppender (XLS) Excel SheetAppender (XLS) Excel SheetAppender (XLS) Excel SheetAppender (XLS) Excel SheetAppender (XLS)

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: annamartin
Created at: 2018-02-22
On NodePit since: 2020-05-23
Last update: 2024-11-21
Created with KNIME version: v4.1.2
Tags: writingsheetsXLSexcelsplit dataloopflow variable

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

Try NodePit Runner!