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.

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

Last updated

Was this helpful?