Skip to main content

Example of a variable formula: Link an Excel spreadsheet to a custom component

Modified: 3 Nov 2025 Tekla Structures 2026
2026
Tekla Structures

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\component_stiffener.xls.

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

  3. Select the custom component in the model, right-click and select Edit custom component.
  4. On the Custom component editor toolbar, click the Display variables button.

    The Variables dialog opens.

  5. To create a new parametric variable, click Add.
  6. Modify the variable as follows:
    1. From 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.

  7. Save the custom component.
  8. Close the custom component editor.
  9. 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.

Submit

Table of Contents