Updating Excel Checkpoints

If an Excel checkpoint fails, you can easily update its baseline data from the test log:

1. Select the "checkpoint failed" message.

2. Open the Details panel of the message.

3. Click the Update the <Checkpoint_Name> checkpoint data link at the bottom of the panel.

   

   Click the image to enlarge it.

4. In the confirmation message, click Yes. TestComplete will replace the stored text data with the actual contents of the Excel file.

It is available for comparison of Excel sheets only.

1. Make sure that the object whose data the checkpoint verifies currently exists in the system.

2. Open the Table element that stores baseline data used by the checkpoint:

   • In the Project Explorer, expand the Stores > Tables node and locate the Table element that stores the data you want to update.

   • Double-click the desired Table element or right-click the element and select Edit from the context menu.

   – or –

   • If you call the checkpoint from a keyword test, right-click the corresponding Table Checkpoint operation in the test and choose Edit Checkpoint Data from the context menu.

3. TestComplete will open the element in the Table Element editor. The editor displays the baseline data that will be used for verification.

4. To update the data, click Update at the top of the editor.

   

   Click the image to enlarge it.

TestComplete will retrieve the actual data from the Excel sheet and store it to the Table element.