Generate Excel 2010 Pivot Table from Java

2
votes

Does anyone know sever side library (free or not - it doesn't matter) which can generate pivot tables in excel 2010 format.

POI can't do it.

Now I'm evaluating SmartXLS but it uses Excel 2007 format. I need couple feature from Excel 2010 - like data field sorting, default pivot table template and etc...

Thanks

2
javaexcelpivot-table

2 Answers

0
votes

For those still looking for this, although SmartXLS or POI might support it by now, they will always run behind with new developments in Excel. If you always want to be able to script the latest features in Excel, you'll be better off coding in .net (or PowerShell, VBScript, VBA)

0
votes

The answer to this question suggests to use X4J, which seems promising but I have not tried it myself.

Java open source library to generate pivot table out of excel