Knime AP 4.7.1. I have two worksheets in a workbook. I have two Excel readers in a workflow. The readers recognize both worksheets, I’ve set the readers to read each worksheet, but they both read the first sheet. Help is appreciated.

@rfeigel there was this issue ( AP-18133 ) and I am not sure if there has been a official solution. But here is a workaround: [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]

Excel Reader Select by Sheet Name Doesn't Work

KNIME Analytics Platform

mlauber71 March 28, 2023, 6:46pm 2

@rfeigel there was this issue (AP-18133) and I am not sure if there has been a official solution. But here is a workaround:

1 Like

Help, to read sheets with loop

Putting multiple Pivots onto one Excel sheet