ReqSuite® Requirements Manager (RM)
Excel Templates

For an appealing visualization of project information, ReqSuite® RM additionally offers mechanisms to export the contents from the database into Excel documents. For this purpose, one or more Excel documents serving as templates can be attached to a specific project template.

An Excel document being such a template is a normal .xlsx-file. At arbitrary positions in the Excel document, suitable commands of ReqSuite® RM have to be inserted, which will be dynamically replaced by project contents during document generation.

Figure 1. Creating the template (left), exported document (right) based on the template
Commands

Currently, the Excel templates support the following commands: “CATEGORY.ATTRIBUTE” and “CATEGORY:TABLE WITH … <ATTRIBUTE>”. Traceability Matrices can be generated through the command “CATEGORY:TABLE WITH … <OTHER CATEGORY> AS OWN COLUMN”.

Just like Word templates, Excel templates also support filter operations “[<FILTER_ATTRIBUTE>{=|<>|<|>|<=|>=} <FILTER_VALUE>]”. The files created from the templates will be re-importable in the future.