Writing to existing Excel file with data but as a true table format using Excel Table Writer component

KNIME Analytics Platform
1

I am trying to use the Excel Table writer but have the final output go to a FIle Server using the SMB node connector. This whole workflow needs to run on our business Hub. I thought I had it all figured out by passing the final File Server path as a string but it still is saying the file / location doesn’t exist.

I wonder if it is simply a formatting error in the path string? Or does the Python script need to know that I am using SMB and not local files?
image

I took this component apart to try and solution this.
Excel Table Writer – KNIME Community Hub

2

Hello @aehrenworth,

The Python script node doesn’t work with remote files (applies to SMB and other remote file systems that KNIME supports). As a work around you can write the file to a temp location in the Python script and then upload it using the SMB KNIME nodes.

Best,
Keerthan

2 Likes