This procedure retrieves a cell in a specific row of a worksheet that matches a given value, regex, or column label.
These required data elements must be present in the automation before using the procedure.
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
get the row's cell
What does it do?
Retrieves the value of a cell from a row in an Excel worksheet.
Where does it go?
This phrase should be written on a new line.
Is it required?
✅ Yes — This phrase is required in the syntax.
⛔ No — This phrase does not require input data.
the value is
What does it do?
Specifies the value of the cell to be identified.
Where does it go?
This phrase should be indented beneath get the row's cell.
Is it required?
🌟 No — This phrase is optional in the syntax.
✅ Yes — A Text value should be specified.
the regular expression is
What does it do?
Specifies a regular expression pattern to match for cell identification.
Where does it go?
This phrase should be indented beneath get the row's cell.
Is it required?
🌟 No — This phrase is optional in the syntax.
✅ Yes — A Text value should be specified.
the column label is
What does it do?
Specifies the name of the column that contains the target cell in the current row.
Where does it go?
This phrase should be indented beneath get the row's cell.
Is it required?
🌟 No — This phrase is optional in the syntax.
✅ Yes — A Text value should be specified.
get the row's cell
the value is "0"
get the row's cell
the regular expression is "\\dBob\\d"
get the row's cell
the column label is "AB"
