Docs  /  Excel Report Builder  /  Edit Evaluations  /  Data Sheets

 Sheet Settings

2023/12/01 • 2 min. to read

In this topic

• Fields
• Excel Table, Fields

The Sheet Settings page is used to set up the general settings of the Data Sheet.

Fields

Sheet Name	Specifies a name for the sheet. If no name is specified, the type of the sheet or the Use as Sheet Name Setting is used. It is additionally possible to specify the placeholder %1 in the text, which is replaced by the type of the sheet or the "Use as Sheet Name" Setting.
Use as Sheet Name	Specifies a Data Sheet line to be used as the name for the sheet.
Add Filters	Specifies whether the filters of the Data Sheet should be added to the worksheet.
Column Headers	Specifies whether or not to add column headers in the worksheet. If there are several parallel tree structures and thus several specifications for a column in the sheet, the first tree structure or the first occurrence determines which header is added.
Column Filters	Specifies whether to turn on filtering for the Column Headers.
Freeze Top Rows	Specifies whether, and if so, how many top rows should remain visible while scrolling through the rest of the worksheet.
Freeze First Columns	Specifies whether, and if so, how many first columns should remain visible while scrolling through the rest of the worksheet.

Excel Table, Fields

Format as Table	Specifies whether the data should be formatted as an Excel Table.
Table Style	Specifies a style for the Excel Table. If the field is empty, the default setting from the Excel Evaluation Setup will be used.
Total Row	Specifies whether to turn on or off the total row of the Excel Table. The Total Row Type can be set for each field individually via the Field Settings of the Data Sheet line(s).
Banded Rows	Specifies whether to display banded rows, in which even columns are formatted differently from odd rows.
Banded Columns	Specifies whether to display banded columns, in which even columns are formatted differently from odd columns.
First Column	Specifies whether to display special formatting for the first column of the Excel Table.
Last Column	Specifies whether to display special formatting for the last column of the Excel Table.