Action group: Excel Is cell empty


Action icon


Version:

  • 7 (net)

The action checks if the value in the cell is empty

Settings 


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 cellThe column of the cell in which the absence of values will be checked.String
Yes
Row of the cellThe cell row in which the absence of values will be checked.Numeric
Yes
Results
ResultVariable to which the value from the cell will be written. If the cell is empty, it is "True", if it is filled, it is "False"Booleantrue





Version:

  • 6 (net)
  • 5 (net)
  • 4 (net)
  • 3 (net)
  • 2 (net)
  • 1 (net)

The action checks if the value in the cell is empty

Settings

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

CellAddress of the cell in which the absence of values will be checked. Fill in the format "XY", where "X" is the column number and "Y" is the row number. The "R1C1" reference style is not supported.String
Yes
Results
ResultVariable to which the value from the cell will be written. If the cell is empty, it is "True", if it is filled, it is "False"Booleantrue
  • Нет меток