Previous Topic: Object Interaction PanelsNext Topic: Usage Scenarios for Simple Objects

Using CA Application Test › Using the Workstation and Console with CA Application Test › Building Test Cases › Complex Object Editor (COE) › Using Data Sets in the COE

Using Data Sets in the COE

A common way to provide data for a Java DTO object is a data set.

A data set, Read DTOs from Excel File, is provided for this purpose.

If the Excel data set exists, the property that contains the data set can be entered as a value for the DTO object.

COE - Using Excel Data Set as input

To initiate the creation of a new DTO data set from the object editor:

  1. When a DTO object appears in the call list, right-click the Name or Actual Type to open a menu.

    COE - Right-click menu on DTO object

  2. Select the data set Read From Excel Data set to display the following window.

    COE - Create XLS Data Set dialog

  3. The parameters on this window are required to initiate the creation of this data set.

Complete the following fields:

Property Key

The property that stores the current values from the data set.

Type of File

Select if it is an existing XLS file or to make a new XLS file.

File

The name of the Excel file that is the template for the DTO data.

Open file in Excel

Opens the spreadsheet in Excel.

End test when no more rows

Ends the test after all rows are read.