Skip to content

Import/Export Tabular Data

Import and export tabular data is supported in MatEditor, which facilitates you to input and output massive data for certain material properties, specifically test data for the hyperelastic and core loss materials.

The import and export buttons are allocated on the top of the Tabular Data Window, as shown in the figure below:
finite_element_analysis_mateditor_test_data_in_plain_text

Default file format

The default file format used in MatEditor/WelSim contains a header block that gives the quantity name, unit, and dependency. This header data allows you to define the units from the external file. The latest version supports plain text and Excel formats. Both formats share a similar schema. The details of each format are discussed below.

  • The comment line starts with ### symbol and will be ignored by the reader.
  • The first row lists the quantity names.
  • The second row shows the units. For the dimensionless quantity, dash symbol - is used.
  • The third row gives the dependency of the quantity, which could be either independent or dependent. For the main table only data, there is only one independent column. While there are two independent columns for that data containing a subtable.
  • The kernel test data start from the fourth row.

Note

The number of columns of data must match.

The plain text data file looks like below:
finite_element_analysis_mateditor_test_data_in_plain_text

The Excel data file looks like below:
finite_element_analysis_mateditor_test_data_in_excel

Formats without header data

MatEditor/WelSim also supports the external data that contains no header information (pure value data). You need to ensure unit consistency when importing such data files. Both plain text and Excel file formats are supported.

The plain text file with no header dat looks like below:
finite_element_analysis_mateditor_test_data_in_excel

Note

Due to the lack of the header information, the units of the imported data is determined by the current units of the Table. In addition, the pivoting column may not be set if the file does not contain such data. For example, a two-column data from an external file will be assumed to be only strain-stress data when you import the Uniaxial Test Data property, the quantity of temperature will not be set.