I have to generate reports in Excel 2007 format using Jasper Reports. So far I have used JExcelAPI, but that only
produces Excel 2000 format. Any ideas on how to create Excel 2007 files? Do I have to use another tool instead of
The Apache POI library can create XLSX files, but I don't know how (or if) JasperReports makes use of POI, or if it's possible to force XLSX output. But since Jasper is open source you can check for yourself if the web site doesn't help.
Are there actual problems opening XLS files in Office 2007, or what prompted the question? It should still work.
With this configuration I can write one excel file with more worksheets only if I set parameter MAXIMUM_ROWS_PER_SHEET to for example 10'000.
Otherwise I get exception saying that max row per sheet exceeded.
I have read that limit comes from POI so I have tried all new versions: