Excel Checkpoint Operation

Applies to TestComplete 15.0, last modified on November 17, 2021

Description

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.

Operation Result

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.

Scripting Analogue

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.

Child Operations

The operation cannot have child operations.

Operation Parameters

The operation has the following parameter:

FileName

The fully qualified name of the Excel file whose content you want to verify.

To edit the operation parameter:

  1. Double-click the operation in your keyword test. TestComplete will call the Checkpoint wizard.

  2. Follow the wizard instructions to specify operation parameters.

– or –

  1. Select the needed operation in your keyword test.

  2. Click the Value cell twice (not double-click) or select the cell and press F2. This will activate the in-place editor.

  3. Click the ellipsis button of the in-place editor. TestComplete will open the Operation Parameters dialog.

  4. In the dialog, specify the operation parameters. For detailed information on how to work with the dialog, see Specifying Operation Parameters.

  5. Click OK to close the dialog and apply changes.

  6. Press Enter to confirm the changes and close the in-place editor, or press Esc to close the editor discarding any changes.

Remarks

The operation is available in the Checkpoints and Excel categories.

See Also

Validating Data in Excel Files
Working with Microsoft Excel Files

Highlight search results