Read Spreadsheet Row Action

Read Spreadsheet Row Action reads cell values from a specified row (or a subset range within a row) of an open worksheet and outputs them as an array of values.

Appearance

In Talos, Read Spreadsheet Row Action appears as a standard rectangular node with a spreadsheet row reader icon.

Properties

As with all Actions, Read Spreadsheet Row Action has a set of unique properties required for its functionality.

Common properties

Common properties inherited from Action.

Display NameString

This is the display name of the action.

By customizing this property, you can differentiate between same-type actions.

Action IDString

Indicates the unique ID of this action.

This property is Read only and it is not customizable

DisabledBoolean

If set to true, this action is considered disabled and will not be executed.

Document VariableString

The variable name containing the open spreadsheet document.

Must refer to a spreadsheet variable opened by a preceding Open Spreadsheet Action.

WorksheetString

The name of the worksheet to read the row from.

Provide the sheet name, e.g., "Sheet1".

RowString

The row number or specific cell range within a row to read.

Can be a single row index (e.g. "5") to read all cells with values in row 5, or a specific range (e.g., "A5:G5") to read only those specified columns.

Output VariableString

The variable name to store the array of read cell values.

Stores the values in an RPA Array object.

Break On EmptyBoolean

Stops reading cell values when the first empty cell in the row is encountered.

If true, stops executing and ignores any remaining cells in the row after encountering an empty cell.

Read EmptyBoolean

Determines whether to include empty cells in the returned array.

If set to true, empty cells are pushed into the array. If false, empty cells are skipped (unless Break On Empty stops execution).