Define which cell to steer

To work with a table, you need to tell the Bot which cell you want to steer.

Identify the cell by defining the following parameters of the Table element:

  • Row or Col defines which row or column the Bot should search

  • Cell identifies the cell in the defined row or column

Table control priceTable in a scanned Module

You can find various examples for identifying a cell at the end of this chapter.

Define a row

To define a row, replace <Row> with one of the following identifiers:

Identifier

Description

$1

First content row of the table.

$last

Last content row of the table.

$<number>

Identify a row by its number. This number excludes the header; for instance, $1 is the first row after the header.

$lastContentRow

Last row that has content.

$firstEmptyRow

First row without content.

If you steer tables via the Excel Modules from the RPA subset, ensure that you have included the first empty row into the defined range.

$header

Header row.

You can also identify a row by specifying a cell value in the Value column (see the example below).

Define a column

To define a column, replace <Col> with one of the following identifiers:

Identifier

Description

<column name>

Identify a column by the name (case-sensitive). You can use wildcards in column names.

$1

First content column of the table.

$last

Last content column of the table.

$<number>

Identify a column by its number. This number excludes the header; for instance, $3 is the third column after the header.

Identify a cell

To identify a cell, replace <Cell> with the respective identifier.

Depending on whether you identify your cell via row or column, the following identifiers are available:

Identifier

Description

<column name>

Identifies the cell in the column with the specified name (case-sensitive).

You can use wildcards in column names.

<row name>

This applies if you have a header column. In this case, the Bot identifies the cell by the <row name> in the column you have defined (case-sensitive).

You can use wildcards in row names.

$1

First cell in the defined row or column.

$<number>

Identify a cell by its number. This number excludes the header; for instance, $3 is the third cell after the header.

$last

Last cell in the defined row or column.

$header

Cell in the header row of the defined column.

$lastContentRow

Last cell that contains a value in the defined column.

$firstEmptyRow

First cell that doesn't contain a value in the defined column.

You can also further limit the search to certain parameters.

For more information, see "Limit the search for a cell".

Examples

The following examples show how to identify cells in the table below. The first row is a header row.

Example table

This Step identifies B4:

Identify a cell

The Bot

  • searches in row number 3

  • identifies the cell whose column name is First Name

This Step identifies A6:

Identify a cell

The Bot

  • searches in the first column

  • identifies the last cell that contains a value within the defined column

This Step identifies D5:

Identify a cell

The Bot

  • searches for a row that contains the value 12348

  • identifies the cell whose column name is CustomerType

This Step identifies C3:

Identify a cell

The Bot

  • searches in row number 3

  • identifies the cell whose column name starts with Last

Let's say that the column ID is now a header column. In this case, the Step below identifies B2.

Identify a cell

The Bot

  • searches in the first column after the header, i.e. in the column FirstName

  • identifies the cell whose row name is 12345

What's next

You have identified your cell. Time to tell the Bot what to do with this cell!

See the following chapters:

Was this information helpful?

Tricentis RPA Studio Manual 2020.2 © Tricentis GmbH