Set Cell

Set Cell

Type: set-cell  ·  Package: DataTable Activities v1.0.0  ·  Output: none

Sets the value of a column in a row (DataRow).

Modifies the table in place

Set Cell changes the row within its table — it returns nothing. The row is usually the iteration row of a For Each or the one returned by Add Data Row / Get Data Row.

How it works

Writes value into column column of row row. The value is coerced to the column type.

Required parameters

Parameter	Editor	Description
row	expression	The row to modify, e.g. = row.
column	text	Column name.
value	expression	The value to set (adjusted to the column type).

Optional parameters

None.

Output

None — modifies the row in place.

Example

Mark each row as processed while looping the table:

For Each   items = = orders   itemVariable = row
 └─ activities:
      Set Cell   row = = row   column = "Status"   value = "Processed"
      Set Cell   row = = row   column = "ProcessedAt"   value = = now()

Clear failure on type mismatch

If the value is not compatible with the column type (e.g. text in an int column), it fails with a clear message naming the column and expected type. An empty or null value is stored as empty (DBNull).

Related activities

• Update Data Row — change several columns at once.
• Get Cell — read a cell.
• For Each — loop through the rows of a table.