Get Cell

Get Cell

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

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

How it works

Reads column column from row row and returns its value. Save it in an output variable.

Required parameters

Parameter	Editor	Description
row	expression	The row to read, e.g. = fila (the For Each iteration variable).
column	text	Column name.

Optional parameters

Ninguno.

Output

Returns a object with the cell value.

Example

For Each   items = = clientes   itemVariable = fila
 └─ activities:
      Get Cell   row = = fila   column = "Correo"   → output: correo
      SMTP Send  to = = str(correo)   subject = "Aviso"

It is almost always simpler with an expression

To read a cell, a direct expression is usually sufficient: = str(row["Correo"]). Get Cell does the same thing in the form of an activity. Use str(...) or num(...) to safely handle empty cells (DBNull). See DataRow.

Related activities

• For Each — loop through the rows of a DataTable.
• Data Types › DataRow — access cells in expressions.