Insert Row

Inserts a new empty row at the specified position in the active sheet.

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.

File Descriptor - File descriptor of the Excel file. This is the identifier returned by the Open Excel node.
Row Number - Row position where the new row will be inserted (1-based index).

This node has no output.

This node has no additional options.

Inserting a row at the beginning:

// File Descriptor: message.excel_fd
// Row Number: 1
// A new blank row is inserted at row 1, existing rows shift down

Inserting a row in the middle:

// Row Number: 5
// A new blank row is inserted at row 5, rows 5 and below shift down

Inserting multiple rows:

// Loop 5 times:
// - Insert Row at position 10
// This inserts 5 new rows starting from row 10

Adding space for new data:

// Row Number: message.insert_position
// Useful for inserting rows dynamically based on calculations

The row is inserted before the specified position. Existing rows shift down.
The new row is completely empty with default formatting.
If the row number is beyond the last used row, the row is inserted at the end.
Row indices are 1-based (row 1 is the first row).
Formulas in other rows that reference shifted rows are automatically updated.

Error	Solution
Row Number must be greater than 0	Provide a valid row position (1 or higher)
Invalid File Descriptor	Ensure the Open Excel node was executed first