Set Path for File
This is a pre-built action in Avo Assure and comes under @Excel element. This action instructs Avo Assure Client to set the path for file of excel sheet. It is an initial step for the Excel operation.
Syntax
Input: <File Path>;<Sheetname in case of excel > (optional)
Output: <Dynamic Variable> ;< Dynamic Variable> (Optional)

Use case/Example

Scenario: Retrieving user Data from an Excel File for Registration
You are testing a user registration feature for a web application, and the test needs to retrieve different sets of user data like names, email addresses, and passwords from an Excel file. It allows you to specify the location of the Excel file so that the test script can access the data directly from it. This is useful when testing scenarios that require retrieving input data from an Excel sheet or writing test results back into it.
Input
Excel File Path: C:\Users\pasarge.ganesh\Downloads\Userdetails.xlsx; Sheet1
Excel Sheet: Userdetails
Expected Result
The path to the Excel file is set correctly, allowing the test script to access the data in the excel file. The user should be able to retrieve userdetails from the excel sheet.
Output
The output variable {result} contains status of execution as pass, which can be utilized for further purposes.
Last updated
Was this helpful?