You can create Excel templates for the export in the Excel file format. These templates allow you to make specific specifications with regard to appearance and formatting of the Excel tables. The output Excel files can be edited in Microsoft Excel as well as in other Office applications that can read this format. An Excel template may, for example, appear as follows:
Example:The first illustration shows the table with the actual data. The two placeholders on this table ("###" and "#H#") are mandatory.
The properties in the second table "Format" define how the different data values in the first table are to be formatted, with each one of them being optional. The following assignments apply:
#H# stands for headers
### stands for the data
#ID# stands for the object ID
#HD# identifies the header data automatically added to the output (such as function definitions for connections)
#F# stands for footers
#RO# stand for properties that are not written back, meaning that they can also not be edited
#RW# stand for properties that are written back, meaning that they can be edited.
If this information in the second table is not present, then the properties are all formatted in the same manner as the cell containing the value "###".
The filled cells in the Excel table thus define the formatting for the respective data values. The sequence in which the data values appear in Excel is defined by the schema settings.
After a successful export, all columns are formatted to optimum width.
Excel macros can also be stored in the template. These are also loaded into the target file.