• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Jakarta POI vs Jasper Reports.

 
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
At my current job, we have a requirement to generate reports in Microsoft XLS format. No advanced XLS capabilities are required. The requirement is just to generate the spreadsheet based on a given template.

Considering this, I am evaluating Jasper Reports and Jakarta POI.

Of these (Jasper reports and POI),

1.Which is less resource intensive and better performing?
2.Which is more flexible?
3.Any other open source projects worth giving a shot for XLS generation?

- Senthil.
[ September 01, 2006: Message edited by: Senthil S Kumar ]
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
There are several libraries that can create XLS files, some of which are listed on this FAQ page. jXLS is particular works with templates.

I don't think there's a need to use JasperReports at all.
 
Senthil S Kumar
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks Ulf. That helps.
 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Three years down the line and I'm asking the same question... (Google is my friend, and turned up this post).
Given developments in both applications (Jasper Reports and POI) - is the position the same?
I've used POI in the past, and feel that a current requirement to use Jasper may be overkill...
 
Ulf Dittmer
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Both libraries have progressed a lot, but if you need to create Excel files (XLS or XLSX), then POI is the premier choice.
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
FYI, Jasper Reports uses the POI libraries to create XLS files.
 
Mike Pickard
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Anthony Alford wrote:FYI, Jasper Reports uses the POI libraries to create XLS files.



I know. That's why I thought it was overkill...
 
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have explored three APIs for excel generation and need to go with one or change requirement accordingly.

Jasper - due to its template based nature of excel generation it is very costly affair to use specially regarding heap usage. Tested in JProbe, it points all jasper classes consuming large amount of heap memory.

POI - It has limit of 65,000 rows with HSSF. I have tested both HSSF and XSSF on the local workstation. I could create 10,000 rows with HSSF and received outofmemory exception, and for XSSF, I could never generate excel of 10,000 rows. Looks expensive. My Jboss heap setting was JAVA_OPTS="-Xms128m -Xmx512m -XX

JXL - very light, and of course is not as rich as POI but can create 65000 rows very easily with above mentioned heap setting on local JBoss server.


Folks, please update your experience about any of above excel generation APIs.

Thanks
Sudheerbabu
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Babu and others thanks for this valuable information. Just curious to know if there is any tool like iReports that facilitates designing of reports because I found it quite handy and also Japser provides abstraction to internal java code generation so one need not bother about writing code for generating cell, workbook etc. Also same report design can be used to generate the report in othere formats like PDF, if demand comes form users, without looking at any additional tools or products and just calling additional API.

These are the adv I found while working with Jasper. So if Memory is not an issue then Jasper could be a more flexible option.

Not Biasing toward Jasper but these are the advantages I found real time.

Thanks
Harish Kumar
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic