Excel - Copy Reference Worksheet to Destination Workbook

Given a reference to a Source Excel Workbook and a Worksheet within it, Copy the worksheet into another Excel Workbook.

The source and destination workbooks must already exist for the node to work.

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 Destination File Path Column

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

Choose Destination Worksheet Name Column

Choose a column from the input table that holds a reference to the destination worksheet name.%%00010Must be a String column.%%00010%%00010Having this explicitly specified allows for a different worksheet name to be specified in the destination workbook instead of the name in the source worksheet that is being copied. %%00010This can allow for the prevention of naming clashes in the destination worksheet, however the handlin of this must be performed prior to inputting into this node.

Choose Source File Path Column

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

Choose Worksheet Name Column

Choose a column from the input could that holds a reference to the source file worksheet name to copy.%%00010Must be a String column.

Nodes

• Column Selection Configuration4 ×
• Column Expressions1 ×
• Column Filter1 ×
• Component Input1 ×
• Component Output1 ×
• Show all 7 nodes

Extensions

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

Links

• No links available