...
Very simple: To create Excel templates, you only need to add mappings in the same way you do it with Word templates. Check the example below:
As you can see above, ${Summary}, ${ReporterUserName} and ${AssigneeUserName} are an example examples of mappings like similar to the ones used on Word templates.
Iterations
Regarding iterations, they are also defined similarly to the Word template definition. Check the example below:
To define an iteration, you need to merge columns and define the "for" inside of those merged cells. The same thing should be made to define the "end" of the iteration. All content between the "for definition " and the "end" will be duplicated for each iteration.
| Info |
|---|
You can install this example via via the Template Store. |
Functions
Differences between Word and Excel definition
| Word | Excel | Why? |
|---|---|---|
| @{title=${Key}|href=${BaseURL}/browse/${Key}} | ${link:title=${Key},href=${BaseURL}/browse/${Key}} | In Excel |
| , @ is not allowed as it is |
| considered as an invalid formula. |
Excel Templates Limitations
There are currently some limitations related to Excel documents (we are still working on this). See the list below:
- Images content are not exported, only metadata is exported. The same thing to with Attachments.
- Images inside of HTML or WIKI markup content aren't are not exported.
We are working on these and will keep you posted.