| Info |
|---|
Check Excel Templates in the Template Store. |
How does it work?
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 of mappings like 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 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 file @ is not allowed as it is recognised as an invalid formula. |
Excel Templates Limitations
There are 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 Attachments.
- Images inside of HTML or WIKI markup content aren't exported.