Excel table designer

All the buttons from the toolbar are explained below.

The status bar displays the following information.

	Meaning	Description
		Unsaved data present Changes are present that have not yet been saved

Within the table designer, create the design for your Excel file to be exported.

By clicking the New in the toolbar, a new table is inserted, all unsaved changes to the current table are lost.

Using the Save button saves the table to your database. When you open your database on another computer, all your tables are still available.

If the current table is stored in your database, the Delete is available. You can delete the current table by clicking the Delete button, this action is irreversible.

In the frame Table box, you determine the properties of your table.

Enter a clear name for your table here, this name will be used within the programme to indicate this table. For example in the table browser. This text will not appear in the actual Excel file.

Enter a short description for your table here, this description is used within the programme to indicate this table. For example, in the table browser. This text does not appear in the actual Excel file.

For each report, you specify whether it has static columns or dynamic columns.

Tables with dynamic columns are displayed with the purple icon. These tables use the columns from the current entity list, with which the export was called. If the export does not come from the entity list, the default columns are used.

Tables with static columns always use a fixed set of columns, these tables are displayed with the blue icon. This allows you to create specific tables with a specific purpose and structure.

This option adds Excel Filters to header. This allows you to directly sort your data further within Excel. This option only works when the header is added.

In the example below and chosen for a header with filters.

With this option, you specify whether the first line in the Excel export should indicate the columns, depending on the application of the exported Excel file, it may be necessary to have no header line or to have one.

In the example below, we chose not to add a header line.

Row height specifies the height of the export line. In this example, a height of 85 is used.

If this option is active, images are made to fit the cell they are placed in. This ensures that all images have a uniform size. If this option is not active, then the image is placed in its original size in the cell and may overlap with other cells/images.

In the frame Columns box, choose which data to include in the table.

The column list displays all the columns to be included in the table. The order in the list corresponds to the order of the columns in the export.

Using the toolbar, add a new column, all fields of the entity as you designed them are available. It is also possible to add the same column several times.

When a column is selected in the list, you can use the toolbar to delete the column.

To adjust the order of the columns, you can move each column up and down when it is selected in the list.

Of the selected column in the column list, you can see its properties in the box below the list.

Custom header allows you to give a column a specific name instead of the default field name.

This option determines whether the width of the column should be determined automatically based on the column's contents. By default, the width of all columns is determined automatically.

If you select the Automatic width option turned off for this column, determine the width of the column here.

The following hotkeys are valid across the entire window, they do not depend on the focus on a particular component

No