История страницы
...
The action gets the color from the specified cell.
Icon
Parameters
Input parameters
Context - The context of the action for working with an Excel document;
Column of the cell - The column of the cell whose color the action will return. For example A;
Column index - The column index of the cell whose color the action will return from;
Row of the cell - The row of the cell whose color from which the action will return. For example: 5;
Output parameters
RGB color - Variable to which the color of the cell will be written in RGB format;
Excel color - Variable to which the cell color will be written in ExcelCellInteriorColor format.
...
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 whose color the action will return from. | String | No | |
Column index | The column index of the cell whose color the action will return from. | Numeric | No | |
Row of the cell | The cell row whose color the action will return from. | Numeric | Yes | |
| Results | ||||
RGB color | Variable to which the color of the cell in RGB format will be written | String | ||
Excel color | Variable to which the cell color will be written in ExcelCellInteriorColor format | String | ||
...
- Assemble a robot scheme consisting of actions:
- Customize the settings for the "Open" action:
- Configure the parameters for the "Get cell color" action:
- Launch the robot using the "Start" button in the top panel.
Result:
The program robot completed successfully. The color of the cell is defined and written to the variable "Color".
...
Обзор
Инструменты контента