What are Excel Reports

Excel reports are a new way to create Micro Focus PPM reports introduced in PPM 9.30. They are completely integrated in PPM, which means that:

  • They run on existing PPM Server and do not require any extra hardware.
  • They do not require any extra software installation besides PPM.
  • They do not require any extra license fees.

Moreover, Excel reports are built on top of the existing PPM in-app reporting solution, like the JSP Reports or the PL/SQL reports. As a result, like any other PPM report, they are run or scheduled from the Create Report menu of PPM, and are defined in a Report Type configured from PPM Workbench.

The major difference with a standard PPM report is that the output of an Excel report is always an Excel file in XLSX format, whereas the output of a JSP report is usually an HTML file.

To summarize, Excel reports are considered to be an improvement of PPM JSP Reports, which means, Excel reports are easier to use, and present the ready-to-use data in Excel files.

Third party libraries for Excel Reports

Micro Focus PPM is using the JETT library to fill the Excel reports templates (http://jett.sourceforge.net/). All features supported by JETT are available in Excel reports. Even though you can find the most important features of this library in this document, we recommend you to go through the official documentation of JETT in order to learn about all the features available. As of PPM 9.40, JETT version 0.80 is used.

The Apache POI library is also used to insert records in the reports in Large Data mode (http://poi.apache.org/). As of PPM 9.40, Apache POI version 3.10 is used.