Read cell From File
This is a pre-built action located under @Excel element, instructs Avo Assure to read the content from an excel file of a specific cell as per the given number of rows and column in input value and save the result in the dynamic variable.
Syntax
Input Value: <Row number>;<Column number>
Row number (Required)
Row number specifies which row in the file to read the cell from
Column number (Required)
Column number specifies which column in that row to read the cell from.
Supported formats:
1) Text
2) Static Values
3) Dynamic Variables
4) Column name as alphabets
Note: In Excel file, there is an authority to user to write a column name as alphabets. It is a supported input form for an excel operation. For Example: Username or Password
Output Value:
Dynamic Variable (Required)
This variable holds the particular cell value
Dynamic Variable (Optional)
This variable stores the result is True and False
Example: Read Specific Cell Data from an Excel File and Store the Result The Read Cell From File action takes the value from the Input Value column (for example, 2;3) and reads the data from the specified row and column (row 2, column 3) in the set Excel file. The retrieved data is stored in the {Cell Value} variable, while the execution status is stored in the {Status} variable, with the following possible values:
True – if the data is read successfully.
False – if reading the data fails.
Last updated
Was this helpful?
