Page Comparison

...

See https://bmpi.atlassian.net/wiki/spaces/CRDOC/pages/3252125697/Working+with+Excel+Templates#Supported-Node-Types for the names to be assigned.

Style and Language Specific Cell Patterns

Whenever a pattern is searched for a node with a specific style, the following names are checked in order:

1. <style>.<pattern>.<reportLanguage>

2. <style>.<pattern>

3. <pattern>.<reportLanguage>

4. <pattern>

Example: the header pattern when rendering a node with style MyStyle in language de will be the first existing one of MyStyle.header.de, MyStyle.header,header.de, header.

Stamping Cell Patterns

Cell patterns are stamped as follows:

• The style of the pattern cells is copied to the stamped cells next rows (or columns for generic tables) in the Excel report. This includes format, font, row height and column width, alignment, wrapping, colors, conditional formatting, merging, etc.

• Some patterns are optional. These are only rendered if defined in the template.

• The content of the pattern cells is evaluated, then copied. All ${...} expressions in the content will be treated as JavaScript expressions on report specific data. The expression can access the following identifiers:

Style and Language Specific Cell Patterns

Whenever a pattern is searched for a node with a specific style, the following names are checked in order:

1. <style>.<pattern>.<reportLanguage>

2. <style>.<pattern>

3. <pattern>.<reportLanguage>

4. <pattern>

...

• Some patterns are optional. These are only rendered if defined in the template.

Templates

The template handling of the Excel channel is very similar to the Word Channel. Each Excel report needs at least a main template to render correctly:

...

For all supported nodes, the following cell patterns are may be rendered:

data: {
  mainTitle?: string;
  subTitle?: string;
  reportName: string;
  params: object // Execution Parameters 
}

"data": {
  "mainTitle": <node"Rückforderbare mainTitle>Quellensteuern",
  "subTitle": <node subTitle>"Vom 01.01.2024 bis 31.03.2024",
  "reportName": <report"Rückforderbare name>Quellensteuern",
  "params": {
    "portfolioId": <report execution parameters> "00001",
    "reportingDate": "2024-03-31",
    ...
  }

data: Issue

"data": {
  "id": <issue id>"rep-2024-03-31-15-6",
  "description": <issue description>"Cell pattern 'data' to stamp DataNode 'returns' not found",
  "severity": "error",
  "source": "rendering"
}

...

For all supported nodes, the following parameters are considered:

"parameters": {
  "style": "ReclWhTax",
  ..."
}

"parameters": {
  "pageBreakBefore": true
}

"parameters": {
  "renderingOptions": {
    "excel": {
      "worksheetName":  {
        "resolved": "Rückforderbare QST"
      },
 
    "repeatHeaders": true
    }
  },
  ...
}

Tables: VerticalTableNode

Not surprisingly, a VerticalTableNode is rendered as rows and columns in Excel. There are two ways of rendering an table in Excel: styled templated and generic.

...

Templated Table Rendering

By specifying a style on the VerticalTableNodeIf there is a columnHeaders pattern (maybe with matching style prefix and language suffix), the table will be rendered row by row. Each row, including the header row, corresponds to a cell pattern. Styled Templated rendering therefore allows full control over the layout in Excel and as well as subselection and reordering of columns.

data: Record<string,string>

"data": {
  "ValueDate": "Valutadatum",
  "TradeDate": "Ex-Datum",
  "TransactionId": "Trx-Id",
  "Amount": "Betrag"
}

data: Record<string,number | string | boolean | Date | null>

"data": {
  "ValueDate": "2024-02-14T00:00:00Z", // as Date instance
  "TradeDate": "2024-02-12T00:00:00Z", // as Date instance
  "TransactionId": "41567",
  "Amount": 11424.3
}

data: { groupName: string }

"data": {
  "groupName": "Current Account EUR"
}

Generic Table Rendering

VerticalTableNodes without a style are If there is no columnHeaders pattern, a VerticalTableNode is rendered in a generic way. This mode of rendering is similar to the Word Channel: each column is rendered individually, depending on its value type. Typical value types are text, amount, count, date. The basic idea is that the style of a column (particularly format and alignment) depends on its value type.

Column related pattern names therefore contain the value type:

data: { header: string }

"data": {
  "header": "Betrag"
}

data: { value: number | string | boolean | Date | null }

"data": {
  "value": 11424.3
}

data: { rowName: string }

"data": {
  "rowName": "Gebühren- und Zinsabrechnung"
}

VerticalTableNode Parameters

"parameters": {
  "renderingOptions": {
    "excel": {
      "repeatHeaders": true
    }
  }
}

"parameters": {
  "renderingOptions": {
    "excel": {
      "tableWidth": 115
    }
  }
}

Worksheets: SectionNode

A SectionNode renders its titles, and may start a new worksheet.

...