Excel reader flow variables KNIME 4.6

[pablobato]

Hi!
I am using Knime 4.6.0 and the reader node doesn’t use the variable set as sheet name.
According to the file handling guide

When will this function be available??
Is there an alternative solution?
Thanks

[elsamuel]

Can you share how you’ve configured the node?

[takbb]

Hi @pablobato , the excel reader does support sheet name being chosen by a flow variable. If it isn’t working for you I suspect you haven’t manually set the “sheet selection” radio button in the configuration. If it is not set to “Select sheet with name”, the sheet name you supply will be ignored.

Alternatively, if you wish to also set that radio button using a flow variable (so it doesn’t matter which option was manually configured) you can choose the option by passing a string flow variable with one of the values
FIRST
NAME
INDEX
which choose “first sheet”, “named sheet” or “sheet at index” respectively:

for example:

If this isn’t the problem you are having, then as @elsamuel says, you will need to share with us your configuration for that node, as it should work.

[mlauber71]

@pablobato is it possible it might be this problem. You might try and force the use of NAME for sheet name by an additional flow variable until the problem is fixed:

[bug or no bug ?] Excel Reader preconfigured work sheet selection options

@Geo what you could do is force the use of sheet_selection = “NAME” thru a Flow Variable in case of doubt. Maybe not the most elegant way but shout provide an additional layer of security. [image] And indeed under certain circumstances it seems to revert to the default value. Not able to reproduce it yet in a constant way. But might be worth looking into, @laaaarsi. [image]