This functionality is only available for certain module packages. Info / Copyright

Importing and exporting XLSX files

ClosedGeneral requirements
  • You have selected a library.
  • You have selected a project.
  • You have selected a configurator.
  • You have opened the Configure and generate selection area.

ClosedStructural requirements

The XLSX file must have specific structure elements so that it can be used in the Project Builder.

The internal name of the corresponding element in the XLSX file must exist so that the contents of an XLSX file can be assigned to the configuration variables, Macro Typicals and Typical Groups available in the Project Builder. If a translated display name exists, it is therefore supplemented with the technically required, model-internal name. The model-internal name is enclosed by braces { }. If no translated display names exist for an element, these braces are not required.

ClosedExample: Internal name and translated display name of a configuration variable
  1. Configuration variable with internal name Var01
  2. Display name of the configuration variable

Here you see the appearance of the internal name and the translated display names of the configuration variable in an XLSX file:

A B

1

*

2

Display name of Var01 {Var01}

Value

3

* The cell A1 of an XLSX file is reserved for the specification of the configurator element.

Note

  • When exchanging data via an XLSX file, only the first worksheet of the XLSX workbook is taken into consideration.
  • In case of a data exchange via an XLSX file, the braces { } in the display name as well as entries in the selection lists of configuration variables should not be used, since the required uniqueness is otherwise not ensured during the import.

ClosedExample: Configurators and elements
  1. Appearance of a configurator with name Configurator in the Designer
  2. Appearance of the configuration elements Element 1 and Element 2 in the Designer
  1. Appearance of a configurator with name Configurator in the Project Builder
  2. Appearance of the configuration elements Element 1 and Element 2 in the Project Builder

The export result of an XLSX file of the configurator element Element 1 is shown here:

A B

1

Element 1 {internalname_Element01}

2

Display name of Var01 {Var01}

Value

3

Display name of Var02 {Var02}

Value

4

Display name of Var03 {Var03}

Value

The higher-level configuration variables are specified as of row 2 of the XLSX file. Column A contains the name, and column B the value for a specific configuration variable. The exact designation of the configuration variable must be entered as the name. The value to be defined must be available for selection in the variable and fit the data type. The order of the variables is irrelevant.

Note

A configuration element only has to be specified during the usage of the silent mode. This is irrelevant during a manual import of an XLSX file in the Project Builder. The contents of cell A1 in the XLSX file are not checked in this use case.

ClosedExample: Basic structure of an XLSX file (without translated display names)
A B

1

2

OP_Measuring_Transformer

True

3

SE_Light_power

True

4

SE_Receptacles_power

2

5

SE_Light_control

True

6

SE_Receptacles_control

2

7

OP_Control_panel

false

8

OP_Panel_Enclosure

True

9

OP_Panel_Control

false

10

SE_Drive_Transport

Frequency Control

11

SE_Method

Electric

ClosedExample: Basic structure of an XLSX file (with translated display names)
A B

1

2

Option: Measuring transducer {OP_Measuring_Transformer}

True

3

Lightning, required for enclosure 1 {SE_Light_power}

True

4

Number of female receptacles required in the enclosure 1 {SE_Receptacles_power}

2

5

Lightning, required for enclosure 2 {SE_Light_control}

True

6

Number of female receptacles required in the enclosure 2 {SE_Receptacles_control}

2

7

Option: Control panel {OP_Control_panel}

false

8

Option: Panel Enclosure {OP_Panel_Enclosure}

True

9

Option: Panel Control {OP_Panel_Control}

false

10

Drive type {SE_Drive_Transport}

Frequency Control

11

Method {SE_Method}

Electric

ClosedInstances and their configuration variables

Instances are introduced with a Header. The name of the instantiable Typical is contained in column A, followed by the configuration variables in the subsequent columns. The instantiable elements including their values for the configuration variables are contained in the rows below the header. A block of instantiable elements must be completed by a blank line.

A B C

1

2

3

InstanceObject1

obj1_parameter1

obj1_parameter2

4

InstanceObject1

Value A

Value B

5

InstanceObject1

Value C

Value D

6

7

InstanceObject2

obj2_parameter1

obj2_parameter2

8

InstanceObject2

Value Y

Value Z

9

Note

The introductory header is displayed in bold in the table only for clarification. In general, formatting has no influence on the processing of an XLSX file by the Project Builder.

ClosedExample: Structure of an XLSX file for the configuration of instances (without translated display names)
A B C

1

2

3

Conveyor

parameter1

parameter2

4

Conveyor

some string .... 1

1234

5

Conveyor

some string .... 2

5678

6

Conveyor

some string .... 3

9012

7

8

Enclosure

9

Enclosure

10

ClosedExport a configuration as an XLSX file
  1. Click Export as XLSX.

    2. Your selection is saved for the next export.

  2. Enter the name and a storage location.
  3. Click Save.
  4. The configuration is exported.

ClosedImport a configuration as an XLSX file
  1. Click Import XLSX file.
  2. Select a file.
  3. Click Open.
  4. The configuration is imported.

Note

  • The specifications in the XLSX file for designation, type and value of a configuration variable must match the elements in the configurator. If the specifications do not match, you receive a corresponding error message. The import will continue if possible.
  • The specifications that were already made in the configurator and are not contained in the imported file are not overwritten.
  • When exchanging data via an XLSX file, only the first worksheet of the XLSX workbook is taken into consideration.

Read more