Open source Java library for creating pivot table from excel

Question

Given an excel file, I want to programmatically create a pivot table. I heard about Aspose.Cells, but this is a paid version. Can someone suggest some open source libraries similar to Aspose.Cells or at least any tutorial link where I can get some help to create a pivot table programmatically.

Answer 1

Try https://github.com/jbaliuka/x4j-analytic , it is open source and designed for summary reports with a huge sheet of data.

There are several other open source libraries to achieve the same, but we developed this library to solve performance problems, we use a temporary file to avoid unnecessary memory consumption and write XML to the stream as raw bytes, to avoid the overhead caused by XML API

See examples https://github.com/jbaliuka/x4j-analytic/blob/master/samples/src/test/java/x4j/samples/X4JEngineTest.java , to implement a basic summary report, it needs an XLSX template, an XML descriptor and a few lines of code.