Examples

Actually, these examples are integration test fixtures. Each contains:

• template.xlsx with a Template file created in MS Excel,
• viewModel.json with a ViewModel - data which will put into the template,
• expected.xlsx with the expected result.
• After tests being run: test-output.xlsx with fresh generated file.

These examples are able to run by using the command line tool, read more.

Id	Example	Explanation
0	FinishCell	Testing FinishCell basic behaviour.
1	EndRow	Testing EndRowCell behaviour
2	Variable	Testing displaying value of view model variables by using VariableCell.
3	WsName	Testing if WsNameCell set worksheet name correctly.
4	Hyperlink	Testing creating hyperlinks by HyperlinkCell.
5	ForEach-simple	Checks simple loop.
6	ForEach-Continue-stripped-table	Checks ContinueCell behaviour, creates stripped table.
7	ForEach-Sum	Checks summing of loop part of column.
8	Delete	Testing deleting variables.
9	ForEach-Average	Checks getting of average of generated table.
10	Formula	Checks formulas.
11	DumpCols	Checks horizontally appending columns.
12	ForEach-special	Checks advance for each usages like looping on worksheets.
13	Merged-cells-fill	Checks merged cells behaviour
14	ForEach-merged	Checks merged cells behaviour
15	ForEach-merged-two-tables	Checks merged cells behaviour
16	ForEach-merged-pyramid	Checks merged cells behaviour
17	TemplateFormula	Dynamic formula creation
18	TemplateString	Dynamic content creation following by custom template string (Hello ${name}).