LogoLogo
About
  • Home
  • Guides
  • BDK
  • REST API
  • Release Notes
  • Getting Started
    • Excel Overview
  • Workbooks
    • Create an Excel File
  • Worksheets
    • Add a Worksheet
    • Get a Worksheet
    • Get Worksheets
    • Get an Item from an Excel Worksheet
    • Extract Text from a Worksheet
    • Remove a Worksheet
    • Save a Worksheet
  • Tables
    • Insert a Table
    • Extract a Table from a Worksheet
    • Get a Singular Table from an Excel Worksheet
    • Delete a Table
  • Rows
    • Get a Row
    • Get a Row's Cell
    • Insert a Row
  • Columns
    • Insert a Column
  • Cells
    • Get a Cell Value
    • Get a Cell's Column Label
    • Get a Cell's Formula
    • Get a Cell's Row Number
    • Set a Cell's Value
  • Changelogs
    • Get Changelog
    • Apply Changelog
Powered by GitBook
On this page
  • Overview
  • Prerequisite Data
  • Syntax
  • Examples

Was this helpful?

Export as PDF
  1. Rows

Get a Row's Cell

Retrieves a cell in a specific row of an Excel worksheet.

Overview

This procedure retrieves a cell in a specific row of a worksheet that matches a given value, regex, or column label.

Prerequisite Data

These required data elements must be present in the automation before using the procedure.

Data Name
Data Type

the row

Excel Row

Syntax

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.

Examples

1. Get the Row's Cell by Value

get the row's cell
    the value is "0"

2. Get the Row's Cell by Regular Expression

get the row's cell
    the regular expression is "\\dBob\\d"

3. Get the Row's Cell by Column Label

get the row's cell
    the column label is "AB"

Last updated 4 days ago

Was this helpful?