it seems the Read Excel Sheet names (XLS) struggles to use variables.
Hi there @mw ,
don’t think it is struggling. Not sure what happens in your case but I get this message when file that URL points to is not there anymore.
I copied in the URL present in the variable and it worked. It worked also with URL type “file:[PATH]” ans well as just the path when not driven by a variable. Will try to provide an example workflow. maybe Murphys Law strikes then in that very same moment …
I can still reproduce the issue with Knime 4.1. have created a workflow to enable testing on other OS.
Hi there @mw,
add some dummy name/string for file. Then a value from flow variable can be used. Some configuration options can’t be left empty.