Read Cell from File

This pre-built action of Avo Assure under @Excel element instructs Avo Assure Client to read the content from the specified cell of an excel file and store the result in-input filed.

Syntax:

Input: <Row number>; <Column number>

Supported formats:

• Text

• Static Values

• Dynamic Variables

• Column name as alphabets

Note: In an Excel file, users can name columns using alphabets, which is a supported input format for Excel operations. For example, "Username"

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

Use case/Example

Scenario: Reading User Credentials from an Excel File

When testing the login functionality of a web application, a user has a set of user credentials (Email and password) stored in an Excel file. Using "Read Cell" action these credentials can be dynamically read during the automated tests. This approach is particularly useful in scenarios that require testing multiple users or varying inputs, ensuring through coverage of the login functionality.

1. Input Data:

• Row no. and column no.: 6;1

2. Expected Result:

It should read the content of the specified row and column number in an input value.

Output: The output variable {result} contains status of execution as pass, which can be utilized for Further work.