Set Path for File

This is a pre-built action located under the @Excel element, instructs Avo Assure to set the file path for the Excel sheet. It is the initial step for Excel operations, and the result is saved in a dynamic variable.

Syntax

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

Argument
Description

File Path (Required)

File Path specifies the location of the file to be used. Supported Input formats:

  1. Text

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

Sheetname in case of excel (optional)

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.

Output Value:

Argument
Description

Dynamic Variable (optional)

This dynamic variable holds the results in True or False

Example

Set path for file (C:\User\Documents\StudentList.xlsx; Sheet1) The Set Path for File action takes the value from the Input Value column (e.g., C:\User\Documents\StudentList.xlsx;Sheet1) and sets the path to access the given file. If the file is an Excel sheet, the specified sheet name (Sheet1) is also selected to work with. The path setup result is stored in the {Path Status} variable, with the following possible values:

  • True – if the path is set successfully

  • False – if the path is not set

Last updated

Was this helpful?