Set cell color Version 10 (Net)
Action group: Excel
Description
The action sets the color to the specified cell.
Action 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 |
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 |
Special conditions of use
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
Example of use:
Task
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.
Solution
Use the actions "Open", "Set cell color", "Save".
Implementation
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.
Result
The program robot completed successfully.
The selected color has been successfully applied to the cell.