3D Structural & BIM Software

Microsoft Excel / OpenOffice.org Calc

This interface provides options for data exchange with the following spreadsheet programs:

  • Microsoft Excel
  • OpenOffice.org Calc
  • Applications supporting the CSV file format

  1. Import to RFEM

    Import

    Values in tables of the Excel or Calc spreadsheet can be imported to RFEM/RSTAB either individually or all at once. Furthermore, it is possible to transfer formulas prepared for the parameterizable input to RFEM/RSTAB.

  2. Export settings for OpenOffice.org Calc

    Export

    All RFEM/RSTAB tables including results can be exported directly to an Excel or Calc spreadsheet or in a CSV file, either individually or all at once. The following export options are available:

    • with table headers
    • only marked cells
    • only selected objects
    • only filled rows
    • only filled tables

    In this way, you can clearly arrange the data to be exported. It is possible to export the formulas used in the program directly as the parameters or in a separate table.

Contact us

Contattaci

Do you have any questions about our products? Do you need advice for your current project? 
Contact us or find various suggested solutions and useful tips on our FAQ page.

+49 9673 9203 0

info@dlubal.com

Knowledge Base | Interface with MS Excel and OpenOffice

  1. Exporting Multiple Tables

    Exporting Multiple Tables

    RFEM and RSTAB provide the export interface (‘File’ → ‘Export’) to export model and load data as well as results to Excel or OpenOffice.org Calc in one step. You can select the tables to be exported in the ‘Export of Tables’ section. The ‘Only selected tables’ option allows you to export only a specific selection of tables. Use the [Select Load Cases and Tables for Export] button to open the corresponding dialog box.

  2. Exporting Results of Selected Objects

    Exporting Results of Selected Objects

    In RFEM and RSTAB, it is possible to export the calculation results to an Excel document.

More Useful Features and Technical Articles