How to import load effects from Excel sheet

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. IDEA StatiCa 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 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 by the values from the Excel sheet, you can use the Replace existing loads checkbox. Otherwise, a new load effect will be created.

Give us feedback. Was this article useful?

Yes No

Become a certified connection design professional

Ready to master analysis, design, and code-check skills of various steel connections for everyday engineering practice? Our online course can help you

Try idea statica for free

Download a free trial version of IDEA StatiCa