Mapping Direct Cells

You can use direct cell mapping to select a single cell to map to/from an Isight scalar parameter or array element or to select a range of cells to map to/from an Isight array parameter of the same size.

  1. Double-click the Excel component icon .
    The Excel Component Editor appears.
  2. From the Excel Component Editor, select the workbook cells that you want to map.

    You can select a single cell to map to an Isight scalar parameter or a continuous block of cells to map to an Isight array parameter of the same size.

  3. Determine the name for the mapped parameter:

    • To map an existing Isight parameter, select a parameter from the Parameter list.

      You can sort the parameters in the list by component. Right-click in the list, and select Group Parameters. The setting is saved as a preference for this component. You can use the Preference option to set the initial default for this option for all applicable component editors. You can also choose to not group parameters for the selected component. For more information about these Preference options, see Setting Parameter Preferences in the Database in the Isight User’s Guide.

    • To map a new Isight parameter, type the name of the new Isight parameter in the Parameter text box. Click the button to define a new parameter in more detail.

  4. 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.

  5. Click the button.

    Isight adds the mapping to the list at the bottom of the editor. The parameter mode, type, and value are set automatically.

  6. Click the button to edit the details for any defined mapping.

    The options available for editing mappings depend on the mappings that you have selected:

    OptionDescription
    All mappings You can modify the action (direction of mapping, input or output) and the sheet.
    Single mappings You can modify the range to which the mapping applies.
    Multiple mappings You can select which options should be set for all selected mappings.
    Array mappings You can specify an additional option to determine the order/orientation of the array to the Excel range (Dim. Order). This option is used primarily when:
    • the array is a square matrix (two dimensions of the same size), or
    • the array is dynamic and either or both dimensions can change at run time.

    You can select the following array mappings:

    • Automatic. The Excel component tries to dynamically match the array dimension sizes with the selected range size at execution time (i.e., it is possible that at times the array can be mapped directly and at other times it can be transposed).
    • Regular. The Excel component maps the array directly as you would see it (i.e., first dimension is rows, second dimension is columns).
    • Transposed. The Excel component transposes the array to map it (i.e., first dimension is columns, second dimension is rows).

       

    To delete a listed mapping, select it and click the button.

  7. Repeat the above steps for each parameter that you want to map.
  8. Set any desired advanced options. See Using Advanced Options.
  9. Click OK to save your changes and to close the Excel Component Editor.