Read Spreadsheet Column Action

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

Appearance

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

Properties

As with all Actions, Read Spreadsheet Column 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 column from.

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

ColumnString

The column identifier or specific cell range within a column to read.

Can be a single column letter (e.g. "C") to read all cells with values in column C, or a specific range (e.g., "C1:C10") to read only those specified rows.

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 column is encountered.

If true, stops executing and ignores any remaining cells in the column 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).