Working with Excel Templates

Patterns

Patterns are cell ranges, defined in the excel template that are used for creating a stamp. Patterns are set in the following way:

Mark the cell range for a new pattern
Head to Formulas → Define Name and set a new name for the cell range. Note: This name is static, and needs to be referenced identically in the implementation

Stamp

From a pattern the implementation creates stamps. When a pattern is loaded it is assigned an object with all relevant keys and values, i.e. data.<key> references this object. The pattern can be overloaded but when it is stamped, it will only insert the values from the pattern as defined in the excel template in the same format (i.e., same number formatting, same font style, font type etc.)

Defined Patterns

Excel Pattern Name	Usage	Available Keys
`headerRow`, `footerRow`	Used as a header, displaying basic report information	`reportLanguage` `portfolioId` `periodLength` `reportName` `reportTypeId` `logo` `reportingDate` `reportTitle`
`columnHeaders`	Column headers of the table	Dependent on the sources of the `columnsConfiguration` of the report type
`posRow.<Importance>.<Indent>`	Rows with explicit indent value for individual positions	Dependent on the sources of the `columnsConfiguration` of the report type. Note: Indents are normally not set and only occur for some building blocks.
`posRow.<Importance>`	Rows used for the individual positions	Dependent on the sources of the `columnsConfiguration` of the report type

Template

The default template for assets list follows the design principle of the NGIS FO-Report.