Excel - Rename Worksheets

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)

Options

Choose "Save as" File Path Column

Choose a column from the input could that holds a reference to "save as" filename for the modified worksheet.%%00010Must be a String Type column.

Choose New Worksheet Name Column

Choose a column from the input table that holds a reference the new name for the selected worksheet.

Choose Source File to Modify Column

Choose a column from the input could that holds a reference to the Excel file to modify.%%00010Must be a String Type column.

Choose Origianl Worksheet Name Column

Choose a column from the input could that holds a reference to the origianl worksheet name to rename.%%00010Must be a String column.

Nodes

• Column Selection Configuration4 ×
• Column Expressions1 ×
• Column Filter1 ×
• Component Input1 ×
• Component Output1 ×
• Merge Variables1 ×
• Python Script (legacy)1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Column Expressions (Labs)
• FeatureKNIME Python 2 Integration (legacy)
• FeatureKNIME Quick Forms

Links

• No links available