Write to Cell in file
Last updated
Avo Assure - User Guide v24.2
Last updated
This pre-built action in Avo Assure and comes under @Excel element instructs Avo Assure Client to write the content as specified in the input column to the specified cell of the Excel sheet.
Input: <Row>; <Column>; <Value>; <Type>
Note: The Row and column number are present in the excel sheet.
Value to be written in the cell
Type of value being passed in excel sheet.
Supported format:
Text
Static Values
Dynamic Variables
Column name as alphabets/integers
Output: <Dynamic Variable> ;< Dynamic Variable> (Optional)
When testing the login functionality of a web application with multiple user credentials, a user wants to store the results as (e.g., "Pass" or "Fail") in excel after every login attempt. Using the "Write to Cell" Action allows they saves the result of every 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 Data: Row and column no.: 5;1; Pass; String
2. Expected Result: It needs to be written as pass in the 5th row of the first column, in the user details sheet.
3. Output: The output variable {Result} contains status of execution as pass, which can be used for Excel work.
