Set range color Version 9 (Net)
Action group: Excel
Description
The action sets the color to the cells of the specified range.
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 |
| Start cell column name | The column name of the start cell of the range. If the field is not filled in, the value from the "Start cell column index" field is taken. | String | No | |
| Start cell column index | Column index of the start cell (beginning of the range) from which the area will be set. If the field is not filled in, the boundary of the used area is taken. | Numeric | No | |
| Start cell row | Row of the start cell of the range. If the field is not filled in, the boundary of the used area is taken. | Numeric | No | |
| End cell column name | The name of the end cell column of the range. If the field is not filled in, the value from the "End cell column index" field is taken. | String | No | |
| End cell column index | The column index of the end cell of the range. If the field is not filled in, the boundary of the used area is taken. | Numeric | No | |
| End cell row | The row of the end cell of the range. If the field is not filled in, the boundary of the area to be used is taken. If the address of the end cell is less than the address of the start cell, the area that is limited to these cells will be used. | Numeric | No | |
| Color | The color to be set in the cells of the range. | String | Yes | |
| RGB code | RGB code to create a customizable color. It is in the format: {value for channel R}, {value for channel G}, {value for channel B}. | String | No | |
Special conditions of use
None.
Example of use
Task
There is an Excel document. You need to set a specific color for cells in the specified ranges.
Solution
Use the actions "Open", Set range color", "Save".
Implementation
- Assemble a robot scheme consisting of actions:
- Configure parameters for the "Open" action:
- Configure the parameters for the "Set range color" action.
- Customize the parameter for the "Save" action.
Result
The result of the performed actions was the setting of the selected color in the specified ranges together with the parameter "RGB - code"
The color of the specified range with the RGB parameter.
Обзор
Инструменты контента