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:
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.
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.
In the Name and Address fields, type your name for the dataset and the Excel range address:
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.
To view all of the data that you defined, click See All:
To view the current values, click a data input:
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: