Insert Column

Inserts a new empty column 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.
Column Number - Column position where the new column will be inserted (1-based index, e.g., 1 for column A, 2 for column B).

This node has no output.

This node has no additional options.

Inserting a column at the beginning:

// File Descriptor: message.excel_fd
// Column Number: 1
// A new blank column is inserted at column A, existing columns shift right

Inserting a column in the middle:

// Column Number: 3
// A new blank column is inserted at column C, columns C and beyond shift right

Adding calculated columns:

// Column Number: 5
// Insert column E for calculations

Inserting multiple columns:

// Loop 3 times:
// - Insert Column at position 10
// This inserts 3 new columns starting from column J

The column is inserted before the specified position. Existing columns shift right.
The new column is completely empty with default formatting.
If the column number exceeds the number of used columns, the column is inserted at the rightmost position of the used range.
Column indices are 1-based (column 1 = A, column 2 = B, etc.).
Formulas in other columns that reference shifted columns are automatically updated.
The width of the new column inherits formatting from adjacent columns.

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