Action group: Excel
The action sets the color to the specified cell.
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 of the cell | The column of the cell in which the color will be set | String | No | |
Column index | The index of the cell column in which the color will be set | Numeric | No | |
Row of the cell | Cell row in which the color will be set | Numeric | Yes | |
RGB code | RGB color code in the format "{value for channel R}, {value for channel G}, {value for channel B}". Example: 134,108,242. Applies when the "Custom" option in the "Color" field is selected | String | No | |
Color | The color to be set in the selected cell | String | Yes | |
If you select "No color" in the "Color" field, the fill value in the cell will become "no fill". When selecting "Custom", the "RGB code" field must be filled in, which must contain the rgb color code in the format " {value for channel R},{value for channel G},{value for channel B}". Example: 134,108,242
There is an empty Excel document. Test.xlsx
It is necessary to change the color of the cell to the available colors, as well as to check the possibility of using RGB - code and set any color for the cell using it.
Use the actions "Open", "Set cell color", "Save".
Assemble a robot scheme consisting of actions:
Set the parameters for the "Open" action.
Set the parameters for the "Set cell color" action 1.
Set the parameters for the "Set cell color" action 2.
Set the parameters for the "Save" action. 
Launch the robot using the "Start" button in the top panel.
The program robot completed successfully.
The selected color has been successfully applied to the cell.
