fbpx

Dlubal (RSTAB, RFEM) model import from Excel

Description

This script imports a Dlubal RSTAB or RFEM model that was previously exported to an Excel file. After starting the script, a dialogue window will ask for the file path of the Excel file, the direction of the Z axis (+, -), and the length unit of measurement (mm, cm, m) of the model to be imported. Also since the Excel file containing the RSTAB or RFEM model data may or may not have certain worksheets, which the script can not check by itself, the existence of these worksheets have to be determined and the checkboxes in the dialogue window checked accordingly. After the script reads out the cross-section definitions from the Excel file, another dialogue window will appear where the user has to review and confirm the section conversions. After this, no further user interaction is required for the import process.

The script can not import all possible kinds of model data from the Excel file. Only data from the following worksheets can be imported:
 - Sections
 - Member Hinges
 - Member Eccentricities
 - Nodes
 - Members
 - Nodal Supports
 - Load Cases
 - [Load case] - Nodal Loads
 - [Load case] - Member Loads
 - Frame Loads - Point

If the import fails, it is advised to open the Descript code in the code editor and inspect the produced error. Maybe the model data, or the import script can be easily tweaked to work in that particular case.

Current version: 1.0 (release date: 2024.02.28.)
Made for Consteel 17 build 3303.

To DOWNLOAD this script, navigate to the MyDescript interface within Consteel, then click the "Edit" button next to the name of the script in the list. From there, the script can be saved to the computer. The availability of the "Edit" button depends on your membership level.
More info about the MyDescript interface and our membership system is available at these links:
https://consteelsoftware.com/manual/descript-cspi/user-interface/
https://consteelsoftware.com/products/offers-licensing/#Membership
Excel
Import

The author

Márton Lendvai

Responsible for planning and testing of software features and engineering-related tasks.