Action group: Excel
The action allows you to insert a column to the left of the one selected by index or name in an Excel document.
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 | |
None.
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
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
