An Excel checkpoint is a test operation that recognizes content of an Excel file and verifies that the recognized data matches the expected data. This can be helpful when testing an application that provides its output as an Excel file. You can use Excel checkpoints to make sure the application provides the expected output and, therefore, works correctly.
In keyword tests, you perform Excel checkpoints with the Excel Checkpoint operation:
In scripts — by using the
If you need to compare a specific sheet of an Excel file, use the
During the test run, TestComplete:
If the actual data and the stored data are reported equal, the checkpoint posts a success message to the test log.
Otherwise, the checkpoint posts an error message to the test log and lists comparison differences in the Detail panel:
For a detailed description of the results Excel checkpoints generate, see Analyzing Excel Verification Results.
To compare Excel files byte by byte, use file checkpoints.
You can iterate through your Excel file and compare the desired data via
if … then … else statements and comparison operators.
If the expected contents of your tested Excel file have changed, you may want to update your Excel checkpoints to use new baseline contents. Instead of updating the baseline data stored in the Stores > Files collection manually, you can command TestComplete to update it automatically.
To learn how to do this, see Updating Excel Checkpoints.