Excel cell updater node not taking flow variables into account

KNIME Analytics Platform
1

In ‘Excel Cell Updater’ node - when using flow variable for defining sheet name of the excel file where the cells will be affected; then the flow variable only affects the first (top most) input port. If you have multiple input ports for the node, then the rest of them are not affected and sheet names for other input ports are set up manually.

2

Hi @Tomaz_Kajtna,

If you’re working with multiple input tables and want to control the target sheet names dynamically via flow variables in the Excel Cell Updater node, make sure to use a StringArray flow variable.

For example, if both inputs should update the same sheet (e.g., "Sheet2"), your flow variable should look like this: [“Sheet2”, “Sheet2”]

image

Each entry in the array corresponds to the respective input table.

This approach ensures that the node correctly assigns the sheet names per input.
Here is an example workflow that shows this setup.

Best,
Keerthan

2 Likes
3

Thanks! Now that you point it out, it seems logical :slight_smile:

1 Like