Skip to main content

Insert Column

Inserts one or more blank columns into an Excel worksheet at a specified position. Existing columns to the right are shifted.

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.

Input​

  • Client Id - The client ID from the Connect node (optional if using direct credentials).
  • Workbook Id - The workbook ID from Get Workbook or Create Workbook node.
  • Worksheet Name - Name of the worksheet. Default is "Sheet1".
  • Column Letter - Column position where insertion starts (e.g., A, B, Z, AA).

Options​

  • Credentials - OAuth2 credentials (optional, alternative to using Client ID).
  • Insert Count - Number of blank columns to insert. Default is 1.

Output​

  • Success - True if columns were inserted successfully.
  • Inserted Column - Column letter where insertion occurred.
  • Columns Inserted - Total number of columns inserted.

Examples​

Insert Single Column:

// Input
Column Letter: "C"

// Inserts 1 blank column at C
// Previous column C becomes column D

Use Cases​

  • Add space for new data columns
  • Insert columns between existing data
  • Reorganize worksheet structure

Common Errors​

ErrInvalidArg - "Workbook Id cannot be empty"

  • Solution: Ensure you've called Get Workbook first