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 the header. |
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 | 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. |
Orientation | Specifies the default print format for the worksheet. |
Fit width to pages | Specifies whether the size of the worksheet should be adjusted to fit on the specified number of pages. |
Rows to repeat at top | Specifies a range to be printed on each page. For example, you can specify '$1:$1' for the first row of the worksheet. |
Columns to repeat at left | Specifies a range to be printed on each page. For example, you can specify '$A:$B' for the first two columns of the worksheet. |
Page Order | Specifies the sequence in which the worksheet data is numbered and printed if it does not fit on one page. |
Finmatics Autonomous Accounting Interface for AI-driven document processing tool by Finmatics. More information AppSource |