Write to Cell in File

This is a pre-built action in Avo Assure and comes under @Excel element. The action instructs Avo Assure Client to write the content as specified in the input column to the referenced cell of the Excel sheet.

Syntax

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

Note:

• Row: The Row and column number are present in the excel sheet.

• Column: Value to be written in the cell

• Value: Type of value being passed in excel sheet.

• Supported format:

1. Text

2. Static Values

3. Dynamic Variables

4. Column name as alphabets/integers

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

Usecase/Example

Scenario: Logging Test Results for User Login Attempts

Suppose you are testing the login functionality of a web application with multiple user credentials. After performing each login attempt, you want to store the result (e.g., "Pass" or "Fail") in an Excel sheet for record-keeping. Using the "Write to Cell" Action allows you to save the result of each login attempt into a specific cell in the Excel file. It verifies that the Excel sheet details are updated correctly with the result of each login attempt.

Input

Row and column no.: 5;1; Pass; String

Expected Result

It needs to be written as pass in the 5th row of the first column, in the userdetails sheet.

Output

The output variable {Result} contains status of execution as pass, which can be used for Excel work.