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)>

Argument	Description
<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:

Argument	Description
<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