Creating Excel sheets with java

Currently I am working on a project where we need to create Excel reports from a datasource. There are several ways to do this programmatically, but our first thought was to do this in Java. We actually abandoned this path later on and went for something with Nodejs, but I’ll share my thoughts on the Java road nonetheless.

There are several Java libraries available which enable read-write of Excel sheet formats.

But wouldn’t it be great to have an Excel template that can be used by non-programmers to create a report and that your program can fill this with data?

Enter Jxls, you can use this library to achieve this.

The default example shows how to create an Excel report with a collection of Java objects.

I specifically wanted to know if it would be possible to iterate through child objects and create rows with those as well. Earlier versions of Jxls could not handle this the way I wanted.

So I altered the demo a bit to answer my question. Maybe someone will benefit from this as well.

The Excel template:

The result:

Here is a link to the altered demo on github.