Action group: Excel
The action sets the format of the specified column values.
| Property | Description | Type | Filling example | Mandatory field |
| Parameters | ||||
| Context | Action context for working with an Excel document | Robin.Excel | Excel context | Yes |
| Column name | Name of the column in which the format of the values will be set. If the field is not filled, then the value from the «Column index» field is taken. | Robin.String | No | |
| Column index | Index of the column to which the action will be applied. | Robin.Numeric | No | |
| Start cell | The index of the first line from the range in which the format will be set | Robin.Numeric | No | |
| End cell | The last line index from the range in which the format will be set | Robin.Numeric | No | |
| Format | Format to be set in the selected column | Robin.String | Yes | |
If the "From"/"To" field value falls outside the area to be used and no "To"/"From" value is specified, the document boundary will be used for the blank parameter.
There is an Excel-document.
Set the format of column D as monetary.
Use the "Open", "Set column data", "Save", "Close" actions.
2. Set the "Open" action parameters.
3.Set the "Set column format" action parameters.
4. Set the "Save" action parameters.
5. Set the "Close" action parameters.
6. Click "Start" and see the result.
The desired column format is set.
