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.
Does it require input data? ⛔ No — This phrase does not require input data.
Is it required? ✅ Yes — This phrase is required in the syntax.
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
.
Does it require input data? ✅ Yes — A Text value should be specified.
Is it required? 🌟 No — This phrase is optional in the syntax.
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
.
Does it require input data? ✅ Yes — A Text value should be specified.
Is it required? 🌟 No — This phrase is optional in the syntax.
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
.
Does it require input data? ✅ Yes — A Text value should be specified.
Is it required? 🌟 No — This phrase is optional in the syntax.
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"