• Post Reply Bookmark Topic Watch Topic
  • New Topic

Excel 2007 with JasperReport  RSS feed

 
Dalibor Kalna
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
 
Martijn Verburg
author
Bartender
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The POI library is one to look at
 
Ulf Dittmer
Rancher
Posts: 42972
73
  • 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
Bartender
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you increase the memory?
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!