I am working on mac (Version KNIME 4.1.1) and I have no longer have the option to select “Relative to” when working with the excel reader and writer nodes.
The option still appears in the node description and old workflows where i used this option are working as normal. However, when i drag new a excel reader/writer to the workflow i cannot select the option. Please help!
Existing node on old workflow:
New node on old workflow:
It went to a farm upstate but might be back someday.
as you noticed this option was removed with 4.1.1. and is planned to be back in future version, don’t worry. Until then you can still use KNIME relative paths by using the KNIME protocol with the Custom URL option. Workflows created with KNIME 4.1.0 that use this option will still execute.
Same applies for nodes that have same configuration dialog.
Tnx for engaging!
you can use Custom URL option with KNIME protocol (
knime://knime.workflow/...) for now. Node description will be updated.
@ipazin Except that Custom URL does not appear to work when you attempt to overwrite files: “Execute failed: Deleting files is not supported for custom URLs”
hmmm… Just tried it out (both Excel Writer and Appender) and works fine on my laptop. I have latest KNIME version - 4.1.2. Which one are you using?
Is there anything specific about your workflows/node configuration? Can you maybe share workflow which isn’t working for you with some dummy Excel files?
I’m on v4.1.1, so I will try updating first. I had the same issue with CSV writer but perhaps they have been fixed already
@ipazin It is fixed in v4.1.2.
yep it is. Just checked changelog and there it is listed:
“ AP-13659: Excel Writer fails to write to Custom URL when “Overwrite existing file” is selected”
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
@ajc and @cpa99dcs!
With new, 4.2.0 version,
Relative to option is back.