История страницы
...
The action returns the value from the specified cell.
Action icon
Action 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 from. For example C.
- 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: 3.
Output parameters
- The output is a variable to which the value from the cell will be written.
...
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 value from which the action will return. | String | НетNo | |
Column index | The column index of the cell whose value the action will return. | Numeric | НетNo | |
Row of the cell | The cell row whose value from which the action will return. | Numeric | ДаYes | |
| Results | ||||
Result | The variable into which the value from the cell will be written. | Object | ||
...
Assemble a robot scheme consisting of actions:
Customize the settings for the "Open" action:
Customize parameters of the "Get cell value" action:
Customize parameters of the "Show message" action.
Launch the robot using the "Start" button in the top panel.
...
Обзор
Инструменты контента