This example shows how to link a parametric variable to an Excel spreadsheet. For example, you can use Excel spreadsheets to check connections.

1. 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.

2. Save the Excel spreadsheet in the model folder: ..\<model>\exceldesign\.

   Alternatively, you can save the spreadsheet in the folder defined with the XS_EXTERNAL_EXCEL_DESIGN_PATH advanced option.

3. On the Custom component editor toolbar, click the Display variables button.

   The Variables dialog box opens.

4. Click Add to create a new parametric variable.
5. Modify the variable as follows:
   1. In the Value type list, select Yes/No.
   2. In the Name box, enter use_externaldesign.
   3. In the Label in dialog box box, enter Use external design.

      

6. Save the custom component.
7. Close the custom component editor.