Read Cell From File

This is a pre-built Action located under the @Excel Element. The functionality of this Action in Avo Assure is to read the content from a specific cell in the Excel file. The result of this operation is stored in a dynamic variable for further use during test execution.

Syntax

Input Value: <Row number>;<Column number>

Argument	Description
<Row number> (Required)	Provide the row number of the Excel sheet from which you want to read the cell value.
<Column number> (Required)	Provide the column number of the Excel sheet from which you want to read the cell value.

Note: When using the Read Cell from File action, it can only read values such as text, static values, and column names represented by alphabets from the file.

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

Argument	Description
<Dynamic Variable> (Required)	This dynamic variable stores the particular cell value from the file.
<Dynamic Variable> (Optional)	This dynamic variable stores the status as True or False.

Example: Reading Specific Cell Data from an Excel File

In this example, we explain how to read data from a specific cell in an Excel file and store the result for further use.

• Action: Read Cell From File

• Input Value: 8;4

  • The row number (8) specifies the row position in the Excel sheet from which the data needs to be read.

  • The column number (4) specifies the column position within the same sheet. Combined with the row number, these coordinates identify the exact cell (Row 8, Column 4) in the Excel file.

• Output Value: {Cell Value}

  • The retrieved cell data (e.g., Pending) is stored in the {Cell Value} dynamic variable

  • If a second output variable is provided, the action returns the status as True/False:

    • True: If the cell data is read successfully.

    • False: If the cell data is not read successfully.

• Logical Explanation: The Read Cell From File action takes the value from the Input Value column 8;4 and reads the data from the specified cell in the configured Excel file. The value fetched from that cell is stored in the {Cell Value} variable (e.g., Pending).