Cell by Cell Compare
Last updated
Last updated
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.
Input: <CSV/Excel file path1>;<Sheet name(optional)>;<CSV/Excel file path2>;<Sheet name(optional)>
Output: <Dynamic Variable>;<Dynamic Variable>(Optional)
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.