Cell by Cell Compare

This is pre-built Action located under the @Generic Element Name. It instructs the Avo Assure Client to compare file by checking cell by cell and save the result in the given output variable.

Note: It can compare pair of Excel files OR CSV files OR an Excel and a CSV file.

Syntax

Input: <CSV/Excel file path1>;<Sheet name(optional)>;<CSV/Excel file path2>;<Sheet name(optional)>

Output: <Dynamic Variable>;<Dynamic Variable>(Optional)

Usecase/Example

Scenario: Comparing Data in Excel Sheets

When you are testing a financial application that exports data to Excel. It’s crucial to verify that the exported data matches the source data cell by cell.

Input

Excel Files to Compare:

Source File: sourceData.xlsx

Exported File: exportedData.xlsx

Using the Action:

In the automation script, the "Cell by Cell Compare" Action is used to compare each cell in the two Excel files. The test checks each cell in both files to ensure that the data matches. If discrepancies are found, the comparison results between the 2 files will be written in variable {result}.

Expected Result

By using the "Cell by Cell Compare" Action in this testing scenario, Avo Assure ensures that the data integrity is maintained during the export process, which is vital for accurate reporting and analysis.

Output

This Action will compare the file and comparison results between the 2 files will be written in variable {result} as ‘True’, which can be utilized for display or other purposes.