Definition and Usage
The Insert Columns to Excel worksheet command is used to insert blank columns into a target Excel sheet.
Note: An Insert columns to Excel worksheet command must to used with a Launch Excel command.
Parameters Values
Set parameters
Parameter | Description |
Excel object | Select an Excel object. |
Insert mode | Select the insert mode, to the left or to the right. |
Column number | Specify the position of the target column. Enter a non-zero integer or a letter. 1 means the first column and -1 means the last column. The blank rows will be inserted to the left or right of this column. |
No. of columns | Specify how many columns to insert. |
Sheet name (optional) | Enter the name of the target worksheet. If empty, the current active sheet will be selected. |
Error Handling
Parameter | Description |
When error occurs | Specify the action to proceed when an error occurs |
Example
This workflow will open the Task.xls file and insert a blank column to the left of the first column of the SheetA in this file.