The workbook must contain the sheets and areas defined in the XML file and they must have the same names as are used in the XML file. Additional sheets and areas in the workbook will be ignored.

For the workbook and XML file to work together, column A of the data area must be named with the same name as the area name in the XML file.

Note! Do not use Scandinavian characters in the name. This will cause an error when opening the template.

Note! Due to the support for an increased number of rows and columns in the .xlsx format, some names are invalid for areas. For example TO1 is a valid cell reference in the .xlsx format and therefore invalid as a name for an area.

The cell on the first row of Area1 following the last data column must be named ACCCODE1 (note the three C letters in ACCCODE1).

The defined area must include columns corresponding to the definition and data columns specified in the XML file. Columns A and B are definition columns showing account code and name respectively. Columns C–E are data columns, showing figures for December and November and their difference.

the Simple Report example template (EX_RT101) the data area, called Area1, consists of cells A3:E6.

Note! Though the area stretches over several columns in the workbook, in the Name Manager it is defined as A3:A6.

The dimensions specified:

•account for definitions columns A–B

•year, month, data type, and document series for data columns C–D

Year, month, data type, document series, and unit are selected by the user when opening the report. Column E is not directly limited by dimension selections but is calculated from the other data columns.