Selective Cell by Cell Compare
Last updated
Avo Assure - User Guide v24.2
Last updated
This is pre-built Action located under the @Generic Element Name. It instructs the Avo Assure Client to compare file by checking Selective 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)>; <Cell selection>; <CSV/Excel file path2>; <Sheet name (optional)>; <Cell selection>; <IgnoreCase (optional)>
Note:
In above syntax user need to give 1st excel file path to get compared with other file, sheet name and the cell selection (for example, if the cell is in B column and on 2nd row then cell selection will be B2) of 1st file along with 2nd CSV/Excel’s file path, cell selection of 2nd file.
If the final argument by the user is specified as ‘ignorecase’ (case insensitive), then the comparison done between the selected cells will be by ignoring the case of the cell values.
Output: <Dynamic Variable>;<Dynamic Variable>(Optional)
Scenario: Comparing Specific Data in Excel Sheets
When you are testing a sales application that generates reports in Excel. Sometimes, you only need to compare specific rows or columns for validation, rather than the entire sheet.
Input:
Excel Files to Compare:
Source File: salesDataSource.xlsx
Exported File: salesDataExported.xlsx
Cells to Compare: Sales figures in column B for specific rows.
Using the Action:
In the automation script, the "Selective Cell by Cell Compare" Action is used to compare selected cells in both Excel files. The test checks only the specified cells to ensure that the data matches. If discrepancies are found, the comparison results between the selected cells of the 2 files will be written in variable {result}.
Expected Result: By using the "Selective Cell by Cell Compare" Action in this testing scenario, Avo Assure streamline the validation process by focusing on relevant data, enhancing efficiency and clarity in testing.
Output: This Action will compare both files and the comparison results between the selected cells of the 2 files will be written in variable {result}, which can be utilized for display or other purposes.