Skip to main content

Insert Column

Inserts a new column in a specified location in an Excel 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 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 a Catch node is used.

Input​

  • Excel File Descriptor - The unique descriptor identifier for the open Excel file. This ID is generated by the Open Excel or the Create Excel node.
  • Column Name - The name of the new column. This is an optional input property. (e.g. B or F)
  • Column Data - The data for the new column to be inserted. This should be a string array. (e.g. ["Boston","London","Miami"])

Output​

  • Excel File Descriptor - The unique descriptor identifier for the open Excel file.

Options​

  • Target - Select where to insert the column:
    • Active Column - Inserts a new column in the active column.
    • Specific Column - Inserts a new column at a position specified by the column name.