Action group: Excel Set cell value


Action icon 

img896.png

Version

  • 8 (net)

Action sets the value to 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 to which the value will be written. If there is already data in the cell, it will be overwritten. The format of the value in the cell will be "General". If the field is not filled in, the value is taken from the "Column index" fieldString
No
Column indexThe column index of the cell to which the value will be written. If there is already data in the cell, it will be overwritten. The format of the value in the cell will be "General"Numeric
No
Row of the cellThe cell row in which the value will be written. If there is already data in the cell, it will be overwritten. The format of the value in the cell will be "General"Numeric
Yes
ValueThe value to be written to the selected cellObject
Yes




Version

  • 7 (net)

Action sets the value to 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 to which the value will be written. If there is already data in the cell, it will be overwritten. The format of the value in the cell will be "General"String
Yes
Row of the cellThe cell row in which the value will be written. If there is already data in the cell, it will be overwritten. The format of the value in the cell will be "General"Numeric
Yes
ValueThe value to be written to the selected cellObject
Yes




Version

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

Action sets the value to 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 where the value will be written. Fill in the format "XY", where "X" is the column number and "Y" is the row number. If there is already data in the cell, it will be overwritten. The format of the value in the cell will be "General"String
Yes
ValueThe value to be written to the selected cellObject
Yes
  • Нет меток