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.
Last updated
Was this helpful?