A group of actions: Excel
The action sets the color of the cells of the specified range
Settings
Property | Description | Type | Filling example | Mandatory field |
Parameters | ||||
Context | Action context for working with an Excel document | Robin.Excel | Excel context | Yes |
Start cell column name | The column name of the starting cell of the range. If the field is not filled, then the value from the «Start cell column index» field is taken. | Robin.String | No | |
Start cell column index | The column index of the starting cell (start of the range) from which the region will be set. If the field is not filled, then the border of the used area is taken. | Robin.Numeric | No | |
Start cell row | Row of the starting cell of the range. If the field is not filled, then the border of the used area is taken. | Robin.Numeric | No | |
End cell column name | The column name of the ending cell of the range. If the field is not filled, then the value from the «End cell column index» field is taken. | Robin.String | No | |
End cell column index | The column index of the ending cell of the range. If the field is not filled, then the border of the used area is taken. | Robin.Numeric | No | |
End cell row | Row of the ending cell of the range. If the field is not filled, then the border of the used area is taken. If the address of the end cell is less than the address of the start cell, then the area that is limited by these cells will be used. | Robin.Numeric | No | |
Color | The color to be set in the cells of the range. | Robin.String | Yes | |
RGB code | RGB code to create a custom color. It is entered in the format: {value for the R channel}, {value for the G channel}, {value for the B channel} | Robin.String | No |
Обзор
Инструменты контента