Excel Reader Select by Sheet Name Doesn't Work

[rfeigel]

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.

[mlauber71]

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

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

[rfeigel]

Thanks @mlauber71. I got the sheet reader to work. I had renamed one of the sheets and the Excel Reader wouldn’t release the old name. Renamed to original name and it works. Frustrating.