Book Image

TestComplete Cookbook

By : Gennadiy Alpaev
Book Image

TestComplete Cookbook

By: Gennadiy Alpaev

Overview of this book

<p>TestComplete is an automated testing tool, designed for advanced and novice testers alike, to create, manage and run tests for any desktop, Web or rich client software. It does not depend on any development tool, or application type. Your tests will work fine with any application regardless of whether it was created in C#, C++, Delphi, Java, or any other development language. TestComplete is the most efficient tool of its kind, in regards to the price and quality of the product.</p> <p>This guide takes a refined approach towards quickly learning the capabilities of TestComplete, using relevant illustrations and practical examples. Each example is consonant with true-to-life situations, which testers would come across sooner or later, while automating tests. With the help of these examples, we will look into complex themes and learn how to test web applications in the most effective manner.</p> <p>Throughout the first chapters, we will be dealing with some fairly simple tasks that are of interest to people new to TestComplete, gradually moving towards advanced-level automation approaches, which are riveting both for novices and experienced TestComplete users.</p> <p>We will explore various methods of tests creation for study (e.g. recording, modification and manual coding with use of different approaches), learn test creation using different methods(each of them being suitable for a specific use-case), learn how to distinguish between different methods for accessing controls elements, selecting a most appropriate approach for each of the cases in view. We will also undertake distributive testing for the sake of shortening the overall time for test launches.</p> <p>This practical guide will help you to answer frequently asked questions relating to automation testing and set the tone for the correct direction of your advancements, which are instrumental to organizing automation in your project.</p>
Table of Contents (19 chapters)
TestComplete Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Auto-detecting Excel driver


The DDT.ExcelDriver method allows auto-detecting the Excel driver with the help of Open Database Connectivity (ODBC) or the Microsoft Access Database Engine (ACE) driver depending on the Excel file format after saving.

To this end, the UseACEDriver parameter is to be used. If you would not like to have these parameters signified explicitly each time, it is possible to write a wrapper function to do this automatically.

How to do it...

To automatically define the type of the driver, we need to perform the following steps:

  1. First we define the required DDTExcel function:

    function DDTExcel(fileName, sheetName)
    {
      var useACE = aqFileSystem.GetFileExtension(fileName) == "xlsx";
      return DDT.ExcelDriver(fileName, sheetName, useACE);
    }
  2. Now we can dismiss the necessity to think about the type of the file as it will be defined automatically. The following two examples will work similarly:

    var data = DDTExcel("C:\\data.xls", "Sheet1");
    var data = DDTExcel("C:\\data.xlsx", "Sheet1...