How to import load effects from Excel sheet

Cet article est aussi disponible en :
To save time or transfer the load from another source file (it can be your global analysis model or just another IDEA StatiCa Connection model), there is an option to input the load values of the table in bulk from a spreadsheet using the XLS Import button. Read the article, and learn how it works!

It is possible to import the load effects from an Excel sheet provided the table is correctly organized. The order of members, as well as of the internal forces and their units, must comply with the IDEA StatiCa Connection project.

Copy (Ctrl+C) the values from the Excel table. If you have prepared more sets of internal forces in the tab (e.g., 10 combinations), you can pile them up in the tab and copy the whole data selection at once. The Connection application will recognize the whole selection of sets and will create a separate load effect for each set.

In IDEA StatiCa Connection, select an existing load effect and start the XLS Import command from the ribbon.

Finally, select the indicated cell below and Paste (Ctrl+V) the values.

If you want to replace the existing load effect with the values from the Excel sheet, you can use the Replace existing loads checkbox. Otherwise, a new load effect will be created.

For more details, see Different ways of load definition.

Essayez IDEA StatiCa gratuitement

Démarrez votre essai aujourd'hui et profitez de 14 jours de plein accès et services gratuitement.

Articles associés

Different ways to define load effects

Load Extreme Selection

How to define correct load position (Forces in)

Equilibrium and supporting member