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


Special conditions of use

None.

Example of use 

Task

There is an Excel document in which values are written. It is required to check if the value in cell C3 is filled. And then display a dialog box with the message "Cell is empty" or "Cell is not empty". 

image2024-1-23_15-33-16.png

Solution

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

Implementation 

  1. Assemble a robot scheme consisting of actions:



  2. Customize the settings for the "Open" action:



  3. Customize the parameters for the "Is cell empty" action:



  4. Set the parameter for the "If" action.



  5. Configure parameters for the "Show message" action (for the "True" branch)



  6. Next, for the "False" branch.

  7. Launch the robot using the "Start" button in the top panel. 

Result 

The program robot completed successfully.



The cell fill alert is displayed in a dialog box.