Looping over all Excel Sheets Loops, but takes only data from first sheet

[hevilp]

Hi,

I’m looping over all Sheets within an Excel File. It is pretty the same like here:
Read all sheets from an excel file – KNIME Community Hub

the problem:
the data which is written within the loop is only from the first sheet.
The loops seems to work fine, but instead of using the data from next sheet, the data from the first sheet is used.

Are there any changes to do with 5.20 to the Worklfow I used?

[ipazin]

Hello @hevilp,

this can happen if Select first sheet with data option is active. See here:

Excel Reader ignores flow variable for sheet!?

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.”

Br,
Ivan

[mlauber71]

@hevilp to be sure you can force the use of a specific name:

[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]