Find Cell Address Spreadsheet Action

Find Cell Address Spreadsheet Action searches a spreadsheet worksheet for a cell containing specific matching text or data and returns its A1-style cell reference (e.g., "B12").

Appearance

In Talos, Find Cell Address Spreadsheet Action appears as a standard rectangular node with a magnifying glass over a spreadsheet cell icon.

Properties

As with all Actions, Find Cell Address Spreadsheet 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 Excel spreadsheet.

Must reference a spreadsheet variable opened by a preceding Open Spreadsheet Action.

WorksheetString

The name of the worksheet to search within.

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

DataString

The text or data to search for inside the worksheet cells.

Supports exact text queries or expression-based values.

Output VariableString

The variable to store the found A1 cell address.

The address (e.g. "A5") is stored as an RPA String variable. If no cell is found, an empty string is returned.