Get Cell

Get Cell

Type: get-cell  ·  Package: DataTable Activities v1.0.5  ·  Output: object

Gets the value of a column from a row (DataRow) — typically the current row inside a For Each over a DataTable. It is the activity form of reading a cell.

How it works

Reads the column of the row and returns its value with the column’s type (text, number, date…). It does not modify the row.

Required parameters

Parameter	Type	Default	Description
row	DataRow	—	The row to read, e.g. row (the For Each iteration variable).
column	string	—	Column name.

Optional parameters

None.

Output

Returns an object with the cell value. If the cell is empty (DBNull), it returns null.

Common errors

Message	Cause and fix
'row' must evaluate to a DataRow.	row is not a row: for example, the null output of Find Data Row when it found nothing, or a whole DataTable. Check that the row exists first.
'column' is required.	The column name is missing.
Column '…' does not belong to table ….	The column does not exist in the row’s table (.NET message). Check the name.

Example

For Each   items = customers   itemVariable = row
 └─ activities:
      Get Cell   row = row   column = "Email"   → output: email
      SMTP Send  to = str(email)   subject = "Notice"

It is almost always simpler with an expression

To read a cell, a direct expression is usually enough: str(row["Email"]). Get Cell does the same as an activity. Use str(...) or num(...) to handle empty cells safely. See DataRow.

Related activities

• Set Cell — write a cell.
• For Each — loop through the rows of a DataTable.
• Data types › DataRow — access cells in expressions.