By Frank Faulstich, Dlubal Engineering Software
RSTAB and RFEM offer several possibilities to transfer results to the spreadsheet program Microsoft Excel to varying extents.
If you want to export a high amount of data, open the “File” menu, select “Export” and set “Microsoft Excel” (1).
It is also possible to export only some selected tables. This function is generally used for the export of high data volume (2).
Often, you only need internal forces of members to perform some special designs in Excel. In this case, we recommend to export data directly out of table 3.5 (3).
Maybe you want to have a closer look at a single member for which you may need the internal forces of each x-location defined on the member. Just look at the result diagram of the relevant member. The diagram window provides a button for Excel export (4). This feature is also available for result diagrams of line support forces as well as sections cutting through surfaces.
For the export of module results export options are provided by almost every add-on module. Open the “File” menu in the relevant additional program and select “Export Tables” (5). All data represented as table in the module will be written into the Excel spreadsheet.
Member diagrams can be displayed as well in many add-on modules where data export to Excel is also possible (6).
A powerful alternative to Excel is Calc, the spreadsheet of Open Office. Just switch the setting (7).