Add column Version 3 (Net)
Action group: Excel
Description
The action allows you to insert a column to the left of the one selected by index or name in an Excel document.
Action icon
Settings of parameters
Property | Description | Type | Example of filling in | Obligatory to fill in the field |
Parameters | ||||
| Context | Action context for working with an Excel document | Excel instance | Excel context | Yes |
Column name | Name of the column before which you want to insert a new column. If the field is not filled in, the value from the "Column index" field is taken | String | No | |
Column index | The index of the column before which you want to insert a new column | Numeric | No | |
Values | If the parameter is filled, the new column will include values from the collection | Collection | No | |
Special conditions of use
None.
Example of use
Task
There is an Excel file.
In it we need to add the "Country" column before the "Letter code" column.
Solution
To do this, let's use the Excel group actions: "Open", "Add column", "Save", "Close".
Implementation
- Assemble a scheme of a robot consisting of actions:
2. Set the parameters in the "Open" action
Create a colletcion "Column" with the necessary data
Set the parameters in the "Add column" action
Set the parameters in the "Save" action
Set the parameters in the "Close" action
Click on the "Start" button and see the result
Result
Обзор
Инструменты контента