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