Seems to be a bunch of these topics on the forum but the solutions don’t work for me. I am using a flow variable to specify the sheet/tab name to read on an XLSX file, but it doesn’t have any effect. [image] I have selected the radio button to “Select sheet with name”: [image] …and the flow variable is set here: [image] But I cannot get the correct name to populate. Thoughts?

I was expecting to see the file content tab showing the data in the tab name that I am specifying in the variable, so that I can configure the reader for the columns and formatting I need. I have figured it out now. I have specified manually the tab I need for Excel Reader configuration purposes, and then when running the loop, the tab name updates as expected. I guess I was expecting something more intuitive here, like an indication in the configuration UI that the sheet name is being controlled by a variable like in most other nodes.

Excel Reader Sheet Name Variable

KNIME Analytics Platform

mlauber71 May 3, 2022, 8:15pm 2

@AndrewDevlin it might be this problem where there already is a ticket (AP-18133). You could try to force excel to use the name by setting it with a flow variable