Creating the Excel Template

The Excel template can be found in Samples\4 - Using a Java pre-processor\2 - Template for Java pre-processor.xlsx. Move it to PPM Server in the templates folder; make sure to put it in reports/preprocessor subfolder and rename it SamplePreprocessorTemplate.xlsx.

This template demonstrates some of the features from the JETT third-party library:

  • Scripting in ${} placeholders to pluralize words when more than 1 item is in a list
  • <jt:if> tag to only show table header cells if there is some data to display in the table
  • <jt:hyperlink> tag to create a link with dynamic text and URL