|Part 3: Extending TestArchitect / Lesson #11: Creating Excel reports using TAUtilities|
Exporting TestArchitect data to Microsoft Excel™ is probably the most common use of TAUtilities. This topic focuses on invoking TAUtilities' APIs from Excel, a COM application program.
In the following example, you will export TestArchitect test module information into Excel, using Excel's Visual Basic, on a Windows-based system. The exported information includes the description, assigned user, created by, date of creation, and status result of each test module residing under a specific test module folder, plus the total number of test modules in the folder.
Once the information is provided, clicking the Generate button results in the designated Excel cells being populated with the required data from the TestArchitect items: