Copy Sheet
Copies a sheet from an excel file and creates a copy in the same file.
Common Properties
- Name - The custom name of the node.
- Color - The custom color of the node.
- Delay Before (sec) - Waits in seconds before executing the node.
- Delay After (sec) - Waits in seconds after executing node.
- Continue On Error - Automation will continue regardless of any error. The default value is false.
info
If the ContinueOnError property is true, no error is caught when the project is executed, even if the Catch node is used.
Input
- Excel File Descriptor - The ID of the excel file descriptor to copy the sheet from. This ID is generated by the Open Excel or the Create Excel node.
- Sheet Name - The name of the sheet to be copied.
- Copied Sheet Name - The name of the sheet to be created from the copied sheet.
Output
- Excel File Descriptor - The ID of the excel file descriptor with the copied sheet. This ID is generated by the Open Excel or the Create Excel node.
Options
- Switch To Sheet - Switches to the copied sheet upon completion of copying. If unchecked, the current sheet is retained.