Using test data from Excel
Test case data can be managed in Excel. This requires an Excel spreadsheet which arranges the test data in rows and columns.
For further information on supported Excel versions, please refer to the System requirements. |
The TestCases are represented by columns, and individual data sets are represented by the rows.
-
The columns A to D contain objects and attributes. Data can be structured by using indentations. The names must be unique.
-
From column F on, the headline contains the business objects, also referred to as instances. Tosca Commander converts them to TestCase names.
-
The rows are filled with data sets.
|
Copying comments from Excel
In Excel you can define comments for business objects. When TestCases are instantiated, these comments are copied to the template instance and shown in the Description column.
Copying comments
Microsoft® Excel templates can be found in the %TRICENTIS_PROJECTS%\ToscaCommander\Templates\BO directory. |
Selecting the instantiation
Instantiation allows various TestCase template instances to be created for TestCases. If you would like to create only certain TestCases from an Excel data source, you can specify them on an extra spreadsheet. This spreadsheet must be named according to the following syntax:
Syntax: |
exec_<Spreadsheet name including test data> |
exec_TC_Object |
Possible instantiations can be selected via the Excel Data source wizard when a TestCase TemplateInstance is created.
Spreadsheet containing instantiations
Excel data source wizard |