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?

Hello @hevilp , this can happen if Select first sheet with data option is active. See 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.” Br, Ivan

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

KNIME Analytics Platform

mlauber71 January 25, 2024, 3:43pm 3

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