Is it possible to get the Excel reader to not only read a path variable but also a sheet name variable? I have an irritating issue that files we receive from an external source have sometimes been named “Sheet” and sometimes "Sheet " with a trailing space, so I cannot specify the sheet name. I did manage to convert both the path and the sheet name for each file into a variable, but there is no option to use that variable under “sheet selection”. I feel like I am missing something simple! Can anyone assist with this? Thanks!

Excel reader sheet variable

mlauber71 June 14, 2022, 12:20pm 4

@JWebb it might be this problem and you could try to force the use of a sheet name. There also is a ticket in the KNIME system (AP-18133).

2 Likes