Multiple Sheet in one Excel File

This workflow demonstrates how to write three files in one Excel file on three sheets.
In the top three branches the names of the sheets are manually input in the corresponding field of the Excel Sheet Appender (XLS) nodes.
In the bottom three branches the names of the categories are output as flow variables in the Row Filter nodes, passed to the Excel Sheet Appender (XLS) nodes and used to create the names of the sheets.

Multiple Sheet in one Excel File

 

Resources

EXAMPLES Server: 01_Data_Access/01_Common_Type_Files/09_Multiple_Sheet_in_one_Excel_File01_Data_Access/01_Common_Type_Files/09_Multiple_Sheet_in_one_Excel_File*
Download a zip-archive

 

 


* Find more about the Examples Server here.
The link will open the workflow directly in KNIME Analytics Platform (requirements: Windows; KNIME Analytics Platform must be installed with the Installer version 3.2.0 or higher). In other cases, please use the link to a zip-archive or open the provided path manually