Rename existing sheets within excel workbooks and save the file (eiter to the same name or a new destination)
The source workbook and original worksheet name must already exist for the node to work.
The new worksheet name cannot be contained within the source worksheet to avoid clashes.
Node requires Python scripting extensions to be installed. The xlwings module must be installed in the python environment (this is a standard module in anaconda)
- Type: TableRename ActionsTable containing the rename actions to perform. Each row will result in one source worksheet being opened, and one worksheet being renamed before the file is saved to the specified destination filename.