Access to file server with python script

Hi all,

I’m currently struggeling with my knime workflow.
I would like to simply add some sheets to my main excel file.
The main excel file has a lot of formulars, so the calculation of the Excel writer action takes too long.
My idea is to improve the perfomance by using a simple python script. Unfortunately I didn’t find a way how to connect to my file server with the python script. Is this a known issue?

Hi,
I think the problem is that the connection to the file server belongs to KNIME’s Java process and for Python a separate process is started. Hence, it is not possible to use the Java object referencing the file server in Python. You can, however, write the file with the Python script into your workflow’s data folder (use the Extract Context Properties node to get the current workflow path, then append /data with a String Manipulation node), and then you can use the Transfer Files node to upload the file to your file server.
Kind regards,
Alexander

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.