Write three files in one Excel file on three sheets

This workflow demonstrates how to write three files in one Excel file on three sheets. It separates values in different sheets based on the person's marital status.

In the top left three branches, the names of the sheets are input manually in the corresponding fields of the Excel Sheet Appender (XLS) nodes.

In the top right 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.

In the lower branch, a Group Loop start node is used to iterate through the categories. The name of the current iteration is passed as a variable to the Excel Sheet Appender (XLS) node and used to create the names of the sheets.

External resources

• Transforming a data cell into a flow variable