Hello, I noticed a strange behavior with the new Excel reader: I created below loop. Using the new Excel reader, KNIME reads the first tab for every iteration, instead of going to the next tab. Switching to the deprecated Excel reader, it iterates correctly. Has anyone experienced similar behavior? Generally I would like to stay with the new reader, but I have not been able to make it work yet. Are there any additional settings in the reader config to make this work? Thanks, Tobias [image]

Try the solution mentioned here: [image] Excel Reader ignores flow variable for sheet!? KNIME Analytics Platform In the configuration for the Excel Reader node, you have told the node to “Select the first sheet with data.” [image] This should be switched to “Select sheet with name.”

Loop Excel reader with sheet name variable does not work with new reader node

KNIME Analytics Platform

elsamuel March 18, 2021, 6:49pm 2

Try the solution mentioned here:

3 Likes