Read cell From File

This is a pre-built action in Avo Assure and comes under @Excel element. The action instructs Avo Assure Client to read the content from an excel file of a specific cell as per the given number of rows and column in input value.

Syntax

Input: <Row number>; <Column number>

• Supported formats:

1) Text

2) Static Values

3) Dynamic Variables

4) Column name as alphabets

Note: In Excel file, there is an authority to user to write a column name as alphabets. It is a supported input form for an excel operation. For Example: Username or Password

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

Use case/Example

Scenario: Reading User Credentials from an Excel File

Suppose you are testing the login functionality of a web application, and you have a set of user credentials (Email and password) stored in an Excel file. You can use the "Read Cell" Action to read these credentials dynamically during your automated tests. This approach is particularly useful in scenarios that require testing multiple users or varying inputs, ensuring through coverage of the login functionality.

Input

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

Expected Result

It should be read the content on given row and column no. in an input value.

Output

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