5.11 excel reader not working

KNIME Analytics Platform
1

dear all

i installed the new 5.11 version and cannot switch the file in the reader anymore.

in a hub workflow the default file can not be changed. whatever i try….

this is EXTREMELY annoying and i also wonder why many settings have been taken out of the reader.

is there a way to get back to the old configuartion window`?

1 Like
2

Hi @And_Z,

I can understand the frustration. For Hub workflows, “Relative to: Current workflow” can restrict file access so the Browse button often looks locked. Switching to “Local File System” helps when you’re running things locally, but it doesn’t fix it in deployed apps.

The most reliable solution can be to pass the file path with flow variables:
• Use a File Chooser or File Upload Widget
• Connect it to the Reader via the flow variable port. Please let me know if this helps.

Best,

Sena.

1 Like
3

Hi,

If the file was stored at google drive or similar, you can use connectors to acess the file, read and write.

Example:

Google Authenticator > Google Sheets Connector > Google sheet reader

If you use excel file, you can use:

Google Authenticator > Google Drive connector > File/folder list > make a row filter to pick only your file and use a file transfer or reader to load the file.

Try it and give us a feedback if it works.

Thanks,

Denis

2 Likes