Is cell empty (Office)

Is cell empty Version 1 (Python)

Action group: Office

Description

The action checks that there is no value in the cell

Action icon

Settings of parameters

Property	Description	Type	Filling example	Mandatory field
Parameters
Context	Action context for ods/xlsx document	Robin.OpenSheetD oc		Yes
Column of the cell	The column of the cell in which the absence of values will be checked	Robin.String		Yes
Row of the cell	Cell string to check for the absence of values	Robin.Numeric		Yes
Results
Result	The variable in which the value from the cell will be written. If the cell: empty, then - «True (True)», filled, then - «False (False)».	Robin.Boolean	true

Special conditions of use

None.

Example of use

Task

There is an Excel-document with values in it. It is required to check if the value in cell C3 is filled. And then display a dialog box with the message "The cell is empty" or "The cell is filled".

Solution

Use the actions "Open", "Is cell empty", "Save", "Show message".

Implementation

Assemble a robot consisting of actions:
Set the parameters for the "Open" action:
Specify the path to the Excel file in the Path to File field.
Set parameters for the "Is cell is empty" action:
In the Context field, specify the context of the open Excel document.
In the "Column of the cell" and "Row of the cell" fields, specify the values C and 3, respectively.
In the "Result" field, specify the previously created variable "boolean variable".
Set the parameter for the "Save" action.
Настроить параметр для действия "Если":
Set parameters for the "Show message" action (for the "Truth" branch)
Next, for the "False" branch.
The final result of the "If" action should look like this:
Launch the robot using the "Start" button in the top panel.