Copy Sheet

Creates a copy of a sheet within the same workbook. The copied sheet includes all data, formatting, and formulas.

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 the node.
• Continue On Error - Automation will continue regardless of any error. The default value is false.

info

If ContinueOnError property is true, no error is caught when the project is executed even if the Catch node is used.

Input

• File Descriptor - File descriptor of the Excel file. This is the identifier returned by the Open Excel node.
• Sheet Name - Name of the sheet to copy (source sheet).
• Copied Sheet Name - Name for the copied sheet (destination name).

Output

This node has no output.

Options

This node has no additional options.

Example

Creating a backup of a sheet:

// File Descriptor: message.excel_fd
// Sheet Name: "Sales Data"
// Copied Sheet Name: "Sales Data Backup"

Creating a template copy:

// File Descriptor: message.excel_fd
// Sheet Name: "Template"
// Copied Sheet Name: "January Report"
// The copied sheet becomes the active sheet

Creating monthly copies:

// Sheet Name: "Monthly Template"
// Copied Sheet Name: message.month_name  // e.g., "January", "February"

Tips

• The copied sheet is placed at the end of the workbook.
• The copied sheet becomes the active sheet after the operation.
• All cell values, formulas, formatting, and structures are copied.
• Charts and images are also copied to the new sheet.
• The new sheet name must be unique within the workbook.

Common Errors

Error	Solution
Sheet Name cannot be empty	Provide the name of the sheet to copy
Copied Sheet Name cannot be empty	Provide a name for the new sheet
Source sheet does not exist	Verify the sheet name is correct
Copied sheet name already exists	Choose a unique name for the copied sheet
Invalid File Descriptor	Ensure the Open Excel node was executed first