Mapping Named Cells/Ranges

Named cells/range mapping is based on information predefined in the Excel workbook prior to loading it into the Excel component. Cells and ranges can be labeled within Excel, and this information can be mapped into your Isight component. For more information about using named cells or ranges, refer to your Excel documentation.

  1. Double-click the Excel component icon .

    The Excel Component Editor appears.

  2. From the Excel Component Editor, perform one of the following:

    • If you have just loaded a Excel workbook and the Named Cells Found dialog box appeared, click Yes.

    • If you are working with an already loaded Excel file and want to use named cells/ranges mapping, click the arrow next to the button, and select Add Named Cells.

    The Named Cells/Ranges dialog box appears.

  3. Select the named cells that you want to map automatically.

    You can choose a single mapping, multiple mappings, or click Select All to select all the mappings.

  4. If desired, change the default action of the mappings by selecting a new action using the button, and clicking Change.

  5. Click OK.

    The new mappings are listed at the bottom of the Excel editor.

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

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