Win a copy of Machine Learning with R: Expert techniques for predictive modeling this week in the Artificial Intelligence and Machine Learning forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Ganesh Patekar

Excel 2007 with JasperReport

 
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi there,

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
Jasper Reports?

Thanks a lot
Dalibor
 
author
Posts: 3281
8
Mac OS X Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The POI library is one to look at
 
Rancher
Posts: 43011
76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Dalibor Kalna
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi and thank for your respones,

actually, versions I'm using are:

JasperReports: 3.0.0
ApachePOI: 2.5.1
JExcelAPI: 2.6

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:

JasperReports: 3.5.3
ApachePOI: 3.6
JExcelAPI: 2.6

Result is OutOfMemory exception, with or without MAXIMUM_ROWS_PER_SHEET parameter set.

I'm using JRSwapFileVirtualizer as well.... Any other ideas I can try?

Thanks a lot
Dalibor
 
Martijn Verburg
author
Posts: 3281
8
Mac OS X Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you increase the memory?
 
Hold that thought. Tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!