Hi all, could you please check my WF, maybe/hopefully there is just sth small missing, I’m not that familiar with loops so far: WF_Read_multiple_files.knwf (29.1 KB) DemoData_2022.xls (49 KB) I managed to read all the spreadsheet names, and have an correct iteration and the correct spreadsheet name, but always with the data from the first spreadsheet, I would like to have the data from each Spreadsheet there, and not only from the first [image] Any ideas what I did wrong? Thank you very much! Maya

@Maya229 it might be this problem. You could try and force the use of sheet name via Flow Variable: [image] [bug or no bug ?] Excel Reader preconfigured work sheet selection options KNIME Analytics Platform @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] [image] Excel Reader - force sheet_selection "NAME" with Flow variable – mlauber71 Excel Reader - force sheet_selection "NAME" with Flow variable

WF Read multiple Spreadsheets

KNIME Analytics Platform

mlauber71 September 14, 2022, 1:40pm 2

@Maya229 it might be this problem. You could try and force the use of sheet name via Flow Variable: