2. Creating a Data Storage

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

To create data-driven tests, you need the input data to be used in these tests. With TestComplete you can use any data source: Excel sheets, database tables, text files, project variables of the table type, and others. 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:

support.smartbear.com/testcomplete/downloads/samples

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.

View Test Data

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.

Prev     Next

See Also

Tutorial Home Page
Data-Driven Testing

Highlight search results