I am able get all sheets out of an excel file and combine them but does anybody know how to extract data from specific cells across multiple sheets in the same excel file. The data contained in the sheets is not the same apart from these two specific cells in the sheets, so I cant combine them and then extract the columns. Thanks

Hi @Page0727 , can you show us how your Excel Reader is configured? It sounds like you are not reading the sheets dynamically within the Loop. You need to make sure that you use these settings: [image] [image] In the Settings tab, choose the “Select sheet with name” option (don’t mind what’s in the drop down, we will override it in the next step) In the Flow Variables tab, select your variable that contains the sheet name from the drop down from the “sheet_name”. This variable will dynamically change value within your loop After all this, you should see this message at the bottom of the Excel Reader on the Settings tab: [image]

Extract data from specific cells from multiple sheets in the same excel file

KNIME Analytics Platform

mlauber71 August 4, 2022, 10:47pm 5

@bruno29a, @Page0727 not sure if this has been fixed but it could make sense to force the use of sheet name via variable:

1 Like