Set Path for File

This action in Avo Assure is available under the @Excel Element. Its functionality is to set the file path for the Excel sheet, which serves as the initial step for performing Excel operations and the result is store in a dynamic variable.

Syntax

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

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

Output Value: <Dynamic Variable>(optional)

Argument	Description
<Dynamic Variable> (optional)	This dynamic variable holds the results in 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 within the Excel file that Avo Assure will work with.

• Output Value: {Status}

  • Avo Assure stores the result of the Set Path for File action in the {Status} variable as True or False:

    • True: If the radio button is selected successfully.

    • False: If the radio button is not selected successfully.

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