63x
004034
2024-01-16

Tables

The Table Export allows you to export all or selected RFEM tables with the results directly into an Excel table or as a CSV file.

List

You can import the export settings from a template or save them as a template.

To import the export settings from a template, select the template from the drop-down list. You can then make adjustments, if necessary.

To create a new template, use the New button, and then enter the template name. Enter the desired settings and click the "Apply" button to save them.

Use the Copy button to copy the template. Then, enter the template name. Enter the desired settings and click the "Apply" button to save them.

Use the User-Defined Name button to rename a user-defined template, and the Delete button to delete it.

Tables to Export

The tables are listed in a directory tree. Select the tables that you want to export.

Transfer Parameters

Select the export format from the drop-down list.

Microsoft Excel

The tables are exported to an XML-based standard file format for Excel and the export file is opened in Microsoft Excel.

CSV

The tables are exported to a text file, organized in rows and columns. Rows are separated by a line break, and columns by a separator. You can specify the separator in the "Options".

XLSX

The tables are exported to an XML-based standard file format for Excel without opening Microsoft Excel.

Formulas and Parameters

Activate the "Export global parameters" option to export the global parameters, defined in the Global Parameters dialog box, as a separate table.

Options

Export table header

Specify whether to export the table header as well. In case you don't select this check box, only the table content is exported.

Selected objects only

Use this check box to only export the data of the selected table rows. The selection is facilitated by the selection synchronization between the graphic and the table, which you can switch on and off using the buttons Select Object in Graphic and Show Object in Tables in the table toolbar.

Filled rows only

If you do not want to export any empty rows, select this check box.

Only filled tables

To only export the tables with data, select this check box.

Export data as plain text

To obtain all data as a plain text, activate this check box.

For the export of result tables, further options are available:

Filter

Select this check box if you want to only include certain objects in the documentation.

Result filters from current table set

Usually, RFEM uses the same parameters for results as for the tables. If you clear the check box that is selected by default, you can prepare the result rows and columns for the printout in the To Display tab according to user-defined criteria, which are independent of the filter criteria for tables (see the Result Table Manager ).

Results ordered by objects, then by loading

By default, results are listed by load cases, combinations, and design situations. If you select the check box, data are printed in the order of the individual object numbers – for example, the results of Load Cases 1 through 5 for Member 1 is followed by the results of these load cases for Member 2, and so on.

Select loading

Activate this check box to only include certain load cases, design situations, or combinations in the documentation. You can then specify the loading in the Load Cases/Combinations tab.

Filter

This section is displayed if selecting the "Filter" check box in the "Options" dialog box section. Here, you can define the objects with the properties or results relevant to you. Then, specify the criterion in the "Filter Type" list by which the objects should be filtered.

Parent section