Importing a Parameter Set from Excel - MapleSim Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : MapleSim : Using MapleSim : Building a Model : Using Parameter Sets : Importing a Parameter Set from Excel

Importing Parameter Sets From an Excel Spreadsheet

MapleSim lets you import parameter sets from an Excel spreadsheet for use in your model simulation.  All imported parameter sets are saved as MapleSim parameter set files (.params) and are available under the Attached Files tab ( ), under Parameter Sets.

To import a parameter set from an Excel spreadsheet

1. 

Open the model into which you want to import the parameter sets.

2. 

Click the Add Apps or Templates tab ( ).

3. 

From the Apps palette, under Utility, select Excel Connectivity.  The App opens in the Analysis window.

4. 

In the Excel Connectivity app, scroll to the Import from Excel section.

5. 

Browse to and select the Excel file you want to import by clicking the  button beside Excel File Name, or enter the name of the file, with its full path, in the Excel File Name field.

 

6. 

Select the name of the Excel spreadsheet from the Excel Spreadsheet Name list.

7. 

(Optional) By default, MapleSim imports all of the columns in the Excel spreadsheet.  To specify a range of columns to import, select Import by Column, and then specify the range in the Column Range fields.

Note: Use the letters at the top of each column to specify the range.  You only need to specify the columns that contain actual parameter values. You do not need to specify the MapleSim Filename Params column because it is imported automatically.  To specify a single column, enter the letter for that column in both of the Column Range fields.

8. 

Select the Import By Column check box and click Import to MapleSim as Parameter Set.  The imported parameter values are now added to your MapleSim model and can be viewed in the Main subsystem default settings window by clicking Parameters ( ) in the Main Toolbar, or by clicking the workspace and from the Properties ( ) tab, clicking Add or Change Parameters.

For more information about accessing the parameter sets from your model, see Using a Parameter Set in a Simulation.

See Also

Using a Parameter Set in a Simulation

Running a Simulation

Saving and Applying Parameter Sets

Deleting a Parameter Set

Renaming a Parameter Set

Specifying Parameter Values

Specifying Parameters for Multiple Components

Comparing Parameter Sets