When testing, you may need to use input data stored in external storages. Microsoft Excel files are among the most popular data storages. TestComplete allows you to use Excel files as storages and retrieve data from them. For example, you can use Excel sheets to store data that will be used in data-driven tests.

TestComplete provides several approaches to retrieving data from Excel files. The topics of this section provide detailed information on these approaches.

Using DB Table Variables to Retrieve Data From Excel Files

Explains how to read data stored in Microsoft Excel files using DB Table variables.

Using the DDTDriver Object to Retrieve Data From Excel Files

Explains how to read data stored in Microsoft Excel files using the DDTDriver object.

Working With Excel Files via COM

Explains how to access data stored in Microsoft Excel files via the Excel.Application COM object.

The first two approaches are suitable for retrieving Excel data in keyword tests and scripts correspondingly. Note that these approaches allow you only to read data from Excel files. If you need not only to read data, but also to modify it within an Excel file, use the Excel.Application COM object.

Working With Microsoft Excel Files

See Also