KB 001790 | Using WebService API in Conjunction with EXCEL and Python

Spreadsheet programs like MS EXCEL are very popular with engineers because they allow you to simply automatize your calculations and quickly output the results. Therefore, combining MS EXCEL used as a graphical interface with Dlubal's WebService API is an obvious choice. By using the free xlwings library for Python, you can control EXCEL, and read and write values. The functionality is described in the following, using an example.

With the release of the structural analysis programs RFEM 6, RSTAB 9, RSECTION 1, and RWIND 2, Dlubal Software introduces a new generation of structural analysis programs. True to the motto "Structural analysis that is fun ...", the program provides users with universal tools with which they can meet all the requirements in structural engineering. Find out more about the latest developments at Dlubal Software in this article.

In this article, you will learn how to model and design cable structures in RFEM 6 or RSTAB 9.

You can open the cross-sections in RSECTION using a direct connection, modify them there, and transfer them back to RFEM/RSTAB. Both RSECTION cross-sections and library cross-sections, with the exception of elliptical, semi-elliptical and virtual joists, can be opened and modified directly in RSECTION by clicking a button.

For example, you can thus adjust the reinforcement layout of user-defined RSECTION cross-sections directly in a local RSECTION environment in RFEM/RSTAB. This feature is currently only available for cross-sections with a uniform distribution type. The shear and longitudinal reinforcement defined for library cross-sections is not imported into RSECTION.

In the Concrete Design add-on, you can design any RSECTION cross-section. Define the concrete cover, shear force, and longitudinal reinforcement directly in RSECTION.

After importing the reinforced RSECTION cross-section into RFEM 6 or RSTAB 9, you can use it for design in the Concrete Design add-on.

Go to Explanatory Video

When performing a design according to EN 1993‑1‑3, it is possible to graphically display a mode shape for the distortional buckling of a cross-section, and for the RSECTION cross-sections.

The mode shape can also be output in RSECTION 1 for library cross-sections.