Set path for File
Last updated
Avo Assure - User Guide v24.2
Last updated
This pre-built action in Avo Assure, located under the @Excel element, instructs the Avo Assure Client to set the file path for an Excel sheet. It serves as the initial step for performing excel operations.
Input: <File Path>;<Sheetname in case of excel > (optional)
Note: In the case of an Excel file with multiple sheets, the user needs to specifies a sheet name as input value to select that particular sheet.
Text
Input file can be: .xls, .xlsx and .csv
Output: <Dynamic Variable> ;< Dynamic Variable> (Optional)
When testing a user registration feature for a web application, the test needs to retrieve different sets of user data like names, email addresses, and passwords from an Excel file. It allows specifying the location of the Excel file for test script to access the data directly from the sheet. This action is useful when testing scenarios that require retrieving input data from an Excel sheet or writing test results back into it.
1. Input Data:
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.
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.
