CSUtils POI Library

The CSUtils POI Library allows to populate Excel files with data, that is read from CentraSite. In particular, you may use the abilities of Excel to create graphical reports or statistics on contents of the CentraSite registry.

The POI library is implemented as an addon for the CSUtils Groovy template engine. Internally the template engine is used to create an XML document, which contains the data to be filled into the Excel spreadsheet.

The easiest possibility to use the report generator is through its command line interface.

Sample template

In order to give an impression of how the template engine works, here's an example:

<workbook
    xmlns:gsp="http://namespaces.csutils.sf.net/groovy/xml/XmlTemplateEngine"
    xmlns="http://namespaces.csutils.sf.net/poi/processor/1.0.0">
  <gsp:scriptlet>
    queryEngine.query("FROM Organization AS o").eachWithIndex{ it, i -&gt;
  </gsp:scriptlet>
    <sheet name="Organizations">
      <cell position="B${i + 3}">${it.name()}</cell>
    </sheet>
  <gsp:scriptlet>
    }
  </gsp:scriptlet>
</workbook>

This example would fill the name of all organizations into the cells B3, B4, ...