Get cell value Version 11 (Net)
Action group: Excel
Description
The action returns the value from 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 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 | ||
Special conditions of use
None.
Example of use
Task
There is an Excel document in which values are written. It is required to get the value from cell C3 and output the result to the dialog box.
Solution
Use the actions "Open", "Get cell value", "Show message".
Implementation
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.
Result
The program robot completed successfully.
The value from cell C3 is retrieved and displayed in the dialog box.
Обзор
Инструменты контента