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)
- Type: TableCopy ActionsTable 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.