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.