Read cell From File
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
<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.
Note:
When using the Read Cell from File action, it can only read values such as text, static values, and column names represented by alphabets from the file.
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 (e.g., 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.