Set column format Version 9 (.Net)
Action group: Excel
Description
The action sets the format of the specified column values.
Action icon
Settings of parameters
| 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 | |
Special conditions of use
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.
Example of use
Task
There is an Excel-document.
Set the format of column D as monetary.
Solution
Use the "Open", "Set column data", "Save", "Close" actions.
Implementation
- Assemble a robot scheme with the 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.
Result
The desired column format is set.
Обзор
Инструменты контента