Skip to main content

InsertColumn

Inserts a new column into an Excel worksheet at a specified column index.

Core Functions

  • Adds a new column to an Excel worksheet
  • Shifts existing columns to the right

Inputs

  • FilePath:Specifies the file path of the Excel file to be updated.

  • Type:: String

  • WorksheetName: Specifies the name of the worksheet where the column will be inserted

  • Type:: String

  • ColumnIndex: Specifies the index position where the new column will be inserted.

  • Type:: Integer

Outputs

  • Output:This activity does not return a direct output value.
  • Type:: None

Short Technical Summary Inserts a new column at the specified index in an Excel worksheet and shifts existing columns accordingly.