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)

Input ports

1. Type: Table
   Copy Actions
   Table containing the copy actions to perform. Each row will result in one source worksheet being copied into the destination workbook and saved. The destination workbook will be saved for each row, making it possible to copy multiple worksheets into the same destination workbook, but it might be slow due to multiple saving and opening actions.

Output ports

1. Type: Table
   Results
   Returns the input table with an additional column showing the results of the actions.