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)

Note:

• In the case of an Excel file with multiple sheets, the user specifies a sheet name as the input value to select the particular sheet.

• Supported Input Formats:

1. Text

2. Input file can be: .xls, .xlsx and .csv

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.