Get Cell Value

This is a pre-built Action located under the captured grid element. The functionality of this action in Avo Assure is to fetch the value present in the specified grid cell based on the input provided. The result is stored in the given dynamic variable for further use during test execution.

Syntax

Input Value: <row>;<col>;<header/body>(optional);<left/right>(optional);<row_attr>(optional);<col_attr>(optional)

Argument
Description

<row> (Required)

Provide the row number which you want to use for the retrieving the cell value from the grid.

<col> (Required)

Provide the column number which you want to use for the retrieving the cell value from the grid.

<header/body>

(Optional)

Provide whether you want to retrieve the value from the header or body of the grid.

<left/right>

(Optional)

Provide the direction you want to use for searching within the grid.

<row_attr> (Optional)

Provide any additional row attribute or identifier you want for accurate targeting.

<col_attr> (Optional)

Provide any additional column attribute or identifier you want for accurate targeting.

Note: If row and column attribute names are specified, the first two inputs are interpreted as attribute values. If attribute names are not specified, the inputs are treated as index values.

Output Value: <Dynamic Variable>;<Dynamic Variable>(Optional)

Argument
Description

<Dynamic Variable> (Required)

This dynamic variable stores the retrieved cell value.

<Dynamic Variable> (Optional)

This dynamic variable stores the status as True or False.

Example 1: Retrieving the Value of a Specific Table Cell

In this example, we are explaining how to retrieve the value present inside a specific cell of a captured grid.

  • Action: Get Cell Value

  • Input Value: 2;3

    • The first argument (2) specifies the row number.

    • The second argument (3) specifies the column number.

  • Output Value: {Value}

    • The value extracted from the specified table cell (Pending) is stored in the {Value} dynamic variable.

    • If a second output variable is provided, the execution status is stored in the {Status} variable with the following possible values:

      • True: If the cell value is retrieved successfully.

      • False: If the cell value is not retrieved successfully.

  • Logical Explanation: The Get Cell Value action reads the details from the Input Value column (2;3). It identifies the table cell located at row 2 and column 3 within the specified section. The action retrieves the content present in that cell (Pending) and stores it in the {Value} variable.

Example 2: Retrieving a Specific Cell Value using All Parameters

In this example, we are explaining how to perform a click action on a specific cell within a captured table based on the provided row, column, and additional table identifying attributes.

  • Action: Get Cell Value

  • Input Value: 4;3;body;left;Tony Smith;Participant

    • The first argument (4) specifies the row number.

    • The second argument (3) specifies the column number.

    • The third argument (body) indicates that the operation should be executed within the table body.

    • The fourth argument (left) defines the search direction for locating the cell.

    • The fifth argument (Tony Smith) serves as the row identifying attribute.

    • The sixth argument (Participant) serves as the column identifying attribute.

  • Output Value: {Value}

    • The value extracted from the specified table cell (Pending) is stored in the {Value} dynamic variable.

    • If a second output variable is provided, the execution status is stored in the {Status} variable with the following possible values:

      • True: If the cell value is retrieved successfully.

      • False: If the cell value is not retrieved successfully.

  • Logical Explanation: The Get Cell Value action reads the details from the Input Value column (4;3;body;left;Tony Smith;Participant). It uses the row number, column number, table section, search direction, and the additional row and column attributes to identify the exact cell within the grid. The action retrieves the content present in that cell (Pending) and stores it in the {Value} variable.

Last updated

Was this helpful?