Find Excel Cell

Find Excel Cell

Type: excel-find-cell  ·  Package: Excel Activities v1.0.0  ·  Output: Dictionary

Searches for a value in the sheet and returns the location of the first matching cell (address, row, and column). It is the equivalent of Excel’s “Search”. Useful for locating a header, finding where a particular piece of data is, or locating a row by its identifier before reading or writing around it.

How it works

It scans the sheet (or the given searchRange) looking for value based on matchType, and returns the first match as a dictionary with its position. If nothing is found, it returns null.

Required parameters

Parameter	Editor	Description
value	expression	The value to look for.

Optional parameters

Parameter	Editor	Description
session	expression	Excel Open session (instead of path).
path	expression	Route to .xlsx (required if there is no session).
sheet	expression	Name or index of the sheet. By default, the first.
matchType	list	Forma de comparar: exact (def.) · contains · starts-with.
searchRange	text	Limit the search to a range, e.g. "A1:Z100". By default, the entire sheet.

Output

Returns a Dictionary with address, row, column, and value from the found cell, or null if there is no match.

Example

Find Excel Cell   path = = asset("datos.xlsx")   value = "Total"   → output: celda
If   condition = = isNull(celda)
 ├─ then:
 │    Log   level = warning   message = "No se encontró la celda 'Total'"
 └─ else:
      Log   message = = "Encontrada en " + celda["address"] + " (fila " + celda["row"] + ")"

Check if you found anything

When the value may not exist, it validates the result with isNull(celda) before reading its keys, so as not to fail when accessing celda["address"].

Related activities

• Read Excel Cell — read a cell at a known position.
• Read Excel Sheet — read the entire sheet and filter with LINQ.