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.
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.