...
In this tutorial ExcelTemplate is being used to populate data in a template set up with styles and formats. This part of the tutorial uses formulas and persists Excel styles.
Setting Up the Template
The goal of this part of the tutorial is how to apply number formats and conditional formatting to ExcelTemplate files and what you can expect as ExcelTemplate imports data.
The final template will look like this:
The bottom of the worksheet has a section for the data that will be imported. Each section has a total row summing all of the values for the section. This formula will expand as ExcelTemplate imports data.
Data Sheets
This sub-report makes use of a data sheet. This is where the data markers will go. It should look something like this:
...