Cell by Cell Compare
This is pre-built Action located under the @Generic Element, instructs the Avo Assure to compare file by checking cell by cell and save the result in the given dynamic variable.
Note: It can compare pair of Excel files OR CSV files OR an Excel and a CSV file.
Syntax
Input Value: <CSV/Excel file path1>;<Sheet name(optional)>;<CSV/Excel file path2>;<Sheet name(optional)>
<csv/Excel file path1>
(Required)
Provide the path to the first file (source or reference), which can be in .csv, .xls, or .xlsx format.
<Sheet name> (Optional)
Specify the sheet name in the first Excel file (if applicable). Note: This is ignored for CSV files.
<csv/Excel file path2> (Optional)
Provide the path to the second file (target/actual file to compare), which can be in .csv, .xls, or .xlsx format.
<Sheet name> (Optional)
Specify the sheet name in the second Excel file (if applicable). Note: This is ignored for CSV files.
Output Value:
<Dynamic Variable>(Optional);<Dynamic Variable>(Optional)
This variable stores the status as true or false
Example 1
Compare an Excel file and a CSV file
The Cell by Cell Compare action performs a comparison between an Excel file and a CSV file (e.g., C:\Files\Report.xlsx;Sheet1;C:\Files\Report.csv). This allows validation of content between formats for consistency. The result of the comparison is stored in the {Comparison Result} variable, with the following possible values:
True – if the comparison is completed successfully
False – if the comparison is not completed

Example 2
Compare two Excel files with sheet names
The Cell by Cell Compare action performs a comparison between two Excel files with specified sheet names (e.g., C:\Files\OldData.xlsx;SheetA;C:\Files\NewData.xlsx;SheetB). This helps verify whether data across sheets has changed or remained consistent. The result of the comparison is stored in the {Comparison Result} variable, with the following possible values:
True – if the comparison is completed successfully
False – if the comparison is not completed

Example 3
Compare two CSV files
The Cell by Cell Compare action performs a comparison between two CSV files (e.g., C:\Files\Jan_Sales.csv;C:\Files\Feb_Sales.csv). The result of the comparison is stored in the {Comparison Result} variable, with the following possible values:
True – if the comparison is completed successfully
False – if the comparison is not completed

Last updated
Was this helpful?