История страницы
Is cell empty Version 8 (Net)
Action group: Excel
...
Description
The action checks whether the value in the cell is empty.
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 | Name of the column from which the data will be obtained. If the field is not filled in, the value from the "Column index" field is taken. | String | No | |
Column index | Index of the column from which the data will be retrieved. Indexing starts from 0. If the "Column of the cell" field is filled, the value in the "Column index" field is ignored. The default value is 0. | Numeric | No | |
Row of the cell | Index of the row from which the data will be retrieved. Indexing starts from 0. | Numeric | Yes | |
| Results | ||||
Result | Variable to which the value from the cell will be written. If the cell is empty, then - "True", if filled, then - "False" | Boolean | true | |
...
Assemble a robot scheme consisting of actions:
Customize the settings for the "Open" action:
Customize the parameters for the "Is cell empty" action:
Set the parameter for the "If" action.
Configure parameters for the "Show message" action (for the "True" branch)
Next, for the "False" branch.
Launch the robot using the "Start" button in the top panel.
Result
The program robot completed successfully.
...
Обзор
Инструменты контента