Action group: Excel Get cell value


Action icon


Version:

  • 10 (net)
  • 9 (net)

Action returns the value from the specified cell

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, the value from which the action will return. If the field is not filled in, the value from the "Column index" field is taken.String
No
Column indexThe column index of the cell whose value the action will return.Numeric
No
Row of the cellThe cell row whose value from which the action will return.Numeric
Yes
Results
ResultThe variable into which the value from the cell will be writtenObject





Version:

  • 8 (net)
  • 7 (net)

Action returns the value from the specified cell

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 whose value from which the action will return.String
Yes
Row of the cellThe cell row whose value from which the action will return.Numeric
Yes
Results
ResultThe variable into which the value from the cell will be writtenObject




Version:

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

Action returns the value from the specified cell

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 whose value the action will return. 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
ResultThe variable into which the value from the cell will be writtenObject

  • Нет меток