Use the Excel Checkpoint operation to validate the data of Excel files against the expected data. You can validate the content of an entire file or a part of it.
When you add the operation to your test, TestComplete displays the Checkpoint wizard that assists you in configuring the operation. To edit parameters of an existing operation, double-click it in your keyword test.
If the recognized Excel data matches the expected contents, the operation returns True and posts the "checkpoint passed" message () to the test log. Otherwise, the operation returns False and posts an error message () to the test log.
The Details panel of the operation’s message in the log describes the difference between the baseline and actual Excel data.
The operation's script analogue depends on whether you validate an entire Excel file or a specific sheet. When you compare an entire file, the operation's analogue is the
File.CheckExcelWorkbook method. Otherwise, the analogue is the Table.Check method.
The operation cannot have child operations.
The operation has the following parameter:
To edit the operation parameter:
Double-click the operation in your keyword test. TestComplete will call the Checkpoint wizard.
Follow the wizard instructions to specify operation parameters.
– or –
Select the needed operation in your keyword test.
Click the Value cell twice (not double-click) or select the cell and press F2. This will activate the in-place editor.
Click the ellipsis button of the in-place editor. TestComplete will open the Operation Parameters dialog.
In the dialog, specify the operation parameters. For detailed information on how to work with the dialog, see Specifying Operation Parameters.
Click OK to close the dialog and apply changes.
Press Enter to confirm the changes and close the in-place editor, or press Esc to close the editor discarding any changes.
The operation is available in the Checkpoints and Excel categories.
Validating Data in Excel Files
Working with Microsoft Excel Files