TestComplete samples (both built-in and additional) are located in the <Users>\Public\Public Documents\TestComplete 15 Samples folder.
Some file managers display the Public Documents folder as Documents.
To create data-driven tests, you need the input data to be used in these tests. Excel sheets, database tables, text files and arrays can be used as data sources. In this tutorial, we will use an Excel 2007 sheet as a data storage.
The Excel file goes with the TestComplete Samples package. To get the file, download the package from our website and run it:
The file will be placed to the following folder:
<TestComplete Samples>\Common\Data-Driven Testing\TestBook.xlsx
Each row of the file stores input values that will be used when creating an order. It also stores the verifying values. They will be used as a baseline copy when verifying created orders.
For TestComplete to be able to read data from this Excel file, you must have Microsoft Office 12.0 Access Database Engine OLE DB Provider installed on your computer. Also, the bitness of this Provider (32- or 64-bit) must match the bitness of TestComplete. For more information on downloading and installing the Provider, see the Requirements section at the beginning of this tutorial.
To create input data for your tests, you can also take advantage of the TestComplete Data Generator Wizard. You can quickly create Table variables and Excel worksheets containing data of various types. See Preparing Test Data.