Build 4.5.0.30 of xlsgen adds a pivot table rendering engine. So far, pivot tables were created (in XLS/XLSX/XLSB/ODS files) but their display was deferred until the corresponding file was opened in Excel. This is no longer true. If you create a pivot table, it is automatically calculated and rendered in any output such as PDF or HTML.

The rendering engine acts upon the pivot table field specifications and properties in order to compute the corresponding rows and columns.

Let's take an example, assuming you have the following data :

Sample pivot table data source for rendering purposes

And let's assume you would like pivot table fields arranged this way :

pivot table fields for rendering purposes

Here is the output, as calculated and rendered by xlsgen :

Pivot table rendering