Duplicate Excel file with new name

KNIME Analytics Platform
4

@beckj sorry for the late reply. Maybe you set up an example of what you want to do. Would there be new sheets in the same excel file oder a new excel file with all the sheets plus one more. Would the sheet need to have special formats?

  • With the transfer you could copy the file as is to a new location (with a new name)
    there you could insert new data in an existing sheet - maybe even keeping the formats (Writer Node Issues - #2 by mlauber71)
  • you could insert data into a new sheet with a new name but you would have to restore the formats with the help of the Continental nodes
  • if you want to copy a sheet to a new name you would need OpenPyxl and Python

So your task will involve some planning. So best to start with building a small dummy scenario that could be extended.

You can rename an Excel file but you will also need Python to do that. Here is a Component that could demonstrate that (hopefully):

1 Like