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

Tekla Structures
Modified: 10 Sep 2021
2024
Tekla Structures

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

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.

The custom component dialog box now contains the Use external design option.

Was this helpful?
Previous
Next