Lookup Range

Searches for a cell containing the given value in a sheet or range.

Behaviour

Risk: None · Idempotent: Yes · Safe to retry: Yes · Recovery: Not replayed after a crash

Package Excel activities Velophex.Excel.Activities 0.7.1-rc.7 · Supported (Core profile) · type id velophex.excel.lookupRange

Properties#

Input#

Sheet#

Sheet · String · Required · Default: Sheet1

Worksheet name.

Range#

Range · String · Optional · Default: Not specified in package metadata

Optional range to search in (e.g. A1:D50).

Search Value#

SearchValue · String · Required · Default: Not specified in package metadata

Text or value to find.

Workbook#

Workbook · ExcelWorkbookReference · Optional · Default: Not specified in package metadata

The Excel file to use. Empty uses the innermost enclosing Use Excel File; set it to the Reference As name of a Use Excel File to use that one.

Output#

Found#

Found · Boolean · Output

Whether matching cell was found.

Cell Coordinate#

CellCoordinate · String · Output

Address of found cell (e.g. B12).

Row Index#

RowIndex · Int32? · Output

1-based row number of found cell.

Column Index#

ColumnIndex · Int32? · Output

1-based column number of found cell.

Rules#

• Must be inside Use Excel File.

Retry and risk#

This activity is safe to retry: running it again after a transient failure does not repeat a side effect. If a run is interrupted and the outcome of a step is unknown, the step is never retried automatically (what to do). How activities declare this: characteristics, retries and risk.

Every activity also has the engine's common properties: Timeout and Continue On Error.

Related activities#

• Append Range (Excel)
• Auto Fill
• Auto Fit Range
• Clear Range
• Copy Paste Range
• Copy Sheet
• Create Sheet
• Create Table

Generated from Velophex.Excel.Activities 0.7.1-rc.7. Category: Excel. Keywords: excel, workbook, xlsx, spreadsheet, lookup, find, search, cell.

Properties

Input

Output

Rules

Retry and risk

Related activities