Mapping Name-Value Cells

You can use name-value mapping to select a 2-by- n or n-by-2 region of cells that represent name-value pairs and to automatically define mappings using those names.

  1. Double-click the Excel component icon .

    The Excel Component Editor appears.

  2. From the Excel Component Editor, select the range of cells that contains both the names for the parameters that you are mapping and the associated values.

    The selected range must contain either 2 rows or 2 columns, with the names of the parameters assumed to be in the left or top cells.

    In the following example five parameters are mapped: Length, FlangeWidth, Height, FlangeThickness, and Web Thickness, whose values are in cells A3 through E3, respectively.



  3. Select the mapping direction:

    • . This option maps the value from an Isight parameter to Excel.

    • . This option maps the value from Excel to an Isight parameter.

  4. Click the arrow next to the button, and select Add Name-Value Mapping.

    Scalar parameters are created automatically based on the names in the selected range and are mapped to the corresponding adjacent value cells. In addition, your mappings are added to the list at the bottom of the editor.

  5. To delete a mapping, select it and click the button, if desired.

  6. If desired, sort the listed mappings by clicking the column heading of the column by which you want to sort.

    Sorting the listed mappings does not affect the order of execution of those mappings. You can control the order using the advanced options. See Using Advanced Options.

  7. Verify that the mapping direction is set properly for each parameter.

    If the mapping is not correct, click in the Action column and select the correct mapping.

  8. Repeat the above steps for the parameters that you want to map.

  9. Set any desired advanced options. See Using Advanced Options.

  10. Click OK to save your changes and to close the Excel Component Editor.