Set Path for File

This is a pre-built Action located under the @Excel Element. The functionality of this Action in Avo Assure is to set the file path for the Excel sheet, which serves as the initial step for performing Excel operations. The result is stored in a dynamic variable for further use during test execution.

Syntax

Input Value: <File Path>;<Sheetname in case of excel>(optional)

Argument	Description
<File Path> (Required)	Provide the file path of the file you want to access. Supported Input file formats: .txt .xls .xlsx .csv
<Sheetname in case of excel> (optional)	Provide the sheet name you want to select from the Excel file.

Output Value: <Dynamic Variable>(optional)

Argument	Description
<Dynamic Variable> (optional)	This dynamic variable stores the status as True or False.

Example: Setting the File Path for an Excel Sheet

In this example, we explain how to set the file path for an Excel sheet and verify whether the path is configured successfully.

• Action: Set Path for File

• Input Value: C:\User\Documents\StudentList.xlsx;Sheet1

  • The file path (C:\User\Documents\StudentList.xlsx) specifies the complete path of the Excel file to be accessed.

  • The sheet name (Sheet1) defines the worksheet in the Excel file that Avo Assure works with.

• Output Value: {Status}

  • The result of the Set Path for File action is stored in this {Status} dynamic variable with the following possible values:

    • True: If the path is set successfully.

    • False: If the path is not set successfully.

• Logical Explanation: The Set Path for File action takes the value from the Input Value column (C:\User\Documents\StudentList.xlsx;Sheet1). This action sets the file path to access the specified Excel sheet and stores the result in the {Status} variable as true.