Accessing data from Excel

Fusion makes it easy to access data though either the Navigation bar or by typing the Excel data address directly.

Accessing data in the Fusion navigation bar

To access data in the navigation bar:

  1. In the Fusion navigation bar, select Data:

    NOTE: You can define datasets to be used and referenced anytime during function executions–similar to the Excel Named Ranges function.

    ../../../../_images/fusion_data_inputs.png

  2. Select the data to be included in the dataset:

    • Selection–Use the currently selected cell(s) as the input.

    • Range or Cell–Define an Excel range, or cell, to use as the input.

      NOTE: This may be a Named Range–a pre-defined Excel variable.

    • Python–Use a Python expression as the input.

  3. In the Name and Address fields, type your name for the dataset and the Excel range address:

    ../../../../_images/fusion_range_input.png

    CAUTION: Avoid using a name that resembles an Excel expression because doing so can cause Fusion to behave unexpectedly.

    EXAMPLE: The dataset name “J1” will cause Fusion to try to convert the J1 cell from the spreadsheet data, not the J1 dataset.

  4. To view all of the data that you defined, click See All:

    ../../../../_images/fusion_data_list.png

  5. To view the current values, click a data input:

    ../../../../_images/fusion_view_data.png

Accessing data by entering an Excel data address

To access data by entering the Excel data address, simply enter the address in a function’s input field:

../../../../_images/fusion_direct_input.png