Create Sheet

Creates a new sheet in the workbook at the specified position.

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.
• New Sheet Name - Name for the new sheet (e.g., "Monthly Report", "Data 2024").
• Sheet Index - Position where the new sheet will be inserted (1-based index). If the index is greater than the number of sheets, the new sheet is added at the end.

Output

This node has no output.

Options

This node has no additional options.

Example

Creating a sheet at the beginning:

// File Descriptor: message.excel_fd
// New Sheet Name: "Summary"
// Sheet Index: 1
// This creates "Summary" as the first sheet

Creating a sheet at the end:

// File Descriptor: message.excel_fd
// New Sheet Name: "Archive"
// Sheet Index: 99  // If workbook has fewer sheets, it's added at the end

Creating multiple sheets:

// 1. Create first sheet
// New Sheet Name: "Q1 Data"
// Sheet Index: 1

// 2. Create second sheet
// New Sheet Name: "Q2 Data"
// Sheet Index: 2

// 3. Create third sheet
// New Sheet Name: "Q3 Data"
// Sheet Index: 3

Tips

• Sheet names must be unique within a workbook.
• Sheet indices are 1-based (position 1 means insert before the first sheet).
• If the specified index exceeds the total number of sheets, the new sheet is added at the end.
• The new sheet is created with default Excel formatting and is empty.
• After creation, the active sheet remains unchanged unless you use Activate Sheet.

Common Errors

Error	Solution
Sheet Name cannot be empty	Provide a valid name for the new sheet
Sheet Index must be greater than 0	Use 1 or higher for the index
Sheet name already exists	Choose a unique name that doesn't exist in the workbook
Invalid File Descriptor	Ensure the Open Excel node was executed first