Adding columns to the Excel file

You configure the BOM to add columns to the Scenarios and Expected Results sheets.

About this task

The columns contained in the Excel scenario file are generated using information from the BOM. The input parameters, the attributes, and the constructor arguments are used to create the input columns in the Excel scenario file. You can also configure the BOM to add columns in the Scenarios and Expected Results sheets.

You can create attributes in the BOM to add new columns in the Scenarios sheet or in the Expected Results sheet.

Procedure

To add columns to the Scenarios and Expected Results sheets:

  1. Create virtual attributes:
    • Writable attributes (“Read/Write” or “Write Only”) for optional columns in the Scenarios sheet

    • Readable attributes (“Read/Write” or “Read Only”) for columns in the Expected Results sheet

  2. Define the BOM to XOM mapping for these virtual attributes:
    • Edit the setter part for a new column in the Scenarios sheet

    • Edit the getter part for a new column in the Expected Results sheet

  3. Select the new available Expected Results options when you generate the Excel scenario file.

Results

To add required columns, you must modify the list of arguments of the testing and simulation constructor, or choose a different testing and simulation constructor.