See Also
The import feature allows you to import data from an Excel worksheet or .CSV file into a model's entities, constants, and graphical functions.
Note: You can import data only into graphical functions or into entities whose values are defined by a constant. You cannot import data into any other entity whose values are defined by an equation.
To use the import feature, you need to create a link between the model and an Excel worksheet or .CSV file. The worksheet or .CSV file contains the names of the model entities into which you want to import data and the values that you want to import.
When you set up an import link, you can choose to create a temporary link or a persistent link. Temporary links allow you to import values one time only. Persistent links are saved and can be reused later to manually import values (On Demand links) or to automatically import values (Dynamic links). Dynamic persistent links import values every time you open the model, start a model run, or resume a model run. On Demand persistent links import values only when you perform a manual import. Whether the import is dynamic or on demand, values are imported only if the data in the file have been changed and the file has been saved since the last import.
You can create as many import links as you want per model.
If you are using Excel files, you can set up export and import links to use the same or different Excel file. For example, you can import values from one file into your model, and then export model run values to a different file to retain the "before" and "after" values in separate files. Or you can have a single file always reflect the most current data in the model, by importing values from a file and then exporting run values to the same file.
If you are using .CSV files, you must set up export and import links to use separate import and export files.
Note: Since the software performs an import when you set up a link, you must have created an import file with valid data formats before you set up the link and you must have saved all changes to the file in order to import its data.
From the Edit menu, choose Import Data.
The Import Data dialog box opens.
When you are finished selecting import link options, click OK.
The selected data are imported into the model.
Note: If the worksheet you selected specifies variable (entity) names that are not included in the model, a warning message appears that tells you which entities were not able to be imported. All other entities are imported.