Microsoft Excel Reports

This report type is based on templates in Microsoft Excel Workbook format.


Report documents based on a Microsoft Excel report may be created in the following file formats:

  • Microsoft PowerPoint Presentation
  • Adobe PDF Document
  • Adobe PDF/A Document

The following tables give information about report elements (see Report Elements) specifically applying when being used in Microsoft Excel Reports:

Text ElementsText elements are referenced in Microsoft Excel templates by using the following format:

%%report_element_code%%

They can be used in any cell as well as the title of a worksheet. However, text elements cannot be a sub-text of a cell; the complete cell must consist of the output of a text element.

Chart Elements 
Sheet Elements 
Image Elements 
trueChart Image Elements
These elements are referenced in Microsoft Excel templates by using the following format:

%%report_element_code%%

They can be used in any cell. However, these elements cannot be a subtext of a cell; the complete cell must consist of the output of such an element.

Table Elements 
Raw Table Element
trueChart Table Elements
Table elements are referenced in Microsoft Excel templates by using the following format:

%%report_element_code%%

They can be used in any cell. However, table elements cannot be a subtext of a cell; the complete cell must consist of the reference to a table element.


Table elements have the following additional attributes when used in Microsoft Excel reports:

Insertion Mode. 

This mode determines how the table will be written to the Microsoft Excel worksheet.

Overwrite.

If you set the insertion mode to this value, the left upper cell of the table will be written to the cell that contains the reference to the report element. All other cells of the table will then be exported to the Microsoft Excel worksheet, overwriting any content that may be contained in the overwritten cells.

Insert Rows.

If you set the insertion mode to this value, starting from row two of the table, a full row will be inserted into the Microsoft Excel worksheet, thus moving all content below that row down.

Insert Cells.

If you set the insertion mode to this value, starting from row two of the table, a number of cells (which equal the number of columns to be written to the Microsoft Excel worksheet) will be inserted, thus moving all content within those columns below that row down.

Delete Row Below.

If you activate this option, the row immediately below the last exported row of the table will be deleted from the Microsoft Excel worksheet after the table has been exported.
Repeater Elements
Repeater elements can be used in two different ways in Microsoft Excel.

Sheet Repeater.

If you want to repeat a sheet, you can place the following reference to the report element to any location of the Microsoft Excel worksheet that you want to be repeated:

{{report_element_code}}

You can only place one sheet repeater per Microsoft Excel worksheet.

Row Repeater. 

If you want to repeat a certain number of rows of a worksheet, you can put the following report element references to the worksheet:

{{report_element_code}} {{/report_element_code}}

Every row in-between these references will be repeated and the two rows that contain the start and end tag will be deleted afterwards. You can have multiple row repeaters per Microsoft Excel worksheet and it is also possible to nest them.


M
Mail is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.