This example shows how to link a parametric variable to an Excel spreadsheet. For example, you can use Excel spreadsheets to check connections.
-
Create an Excel spreadsheet.
The name of the spreadsheet file must be component_"component_name".xls. For example, component_stiffener.xls for a custom component whose name is stiffener.
-
Save the Excel spreadsheet in
the model folder:
..\<model>\exceldesign\component_stiffener.xls.
Alternatively, you can save the spreadsheet in the folder defined with the
XS_EXTERNAL_EXCEL_DESIGN_PATHadvanced option. - Select the custom component in the model, right-click and select Edit custom component.
-
On
the Custom component editor toolbar, click the Display variables
button.
The Variables dialog opens.
- To create a new parametric variable, click Add.
-
Modify the variable as follows:
- From the Value type list, select Yes/No.
- In the Name box, enter use_externaldesign.
-
In the Label in dialog box box, enter Use external design.

- Save the custom component.
- Close the custom component editor.
-
Select the custom component in
the model, and open the custom component dialog.
The option to use external design is visible in the custom component's dialog.