wood burning stoves 2.0*
The moose likes Other Open Source Projects and the fly likes Jakarta POI vs Jasper Reports. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Jakarta POI vs Jasper Reports." Watch "Jakarta POI vs Jasper Reports." New topic
Author

Jakarta POI vs Jasper Reports.

Senthil S Kumar
Greenhorn

Joined: Aug 13, 2006
Posts: 10
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 ]
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42286
    
  64
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.


Ping & DNS - my free Android networking tools app
Senthil S Kumar
Greenhorn

Joined: Aug 13, 2006
Posts: 10
Thanks Ulf. That helps.
Mike Pickard
Greenhorn

Joined: Feb 22, 2009
Posts: 3
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
Marshal

Joined: Mar 22, 2005
Posts: 42286
    
  64
Both libraries have progressed a lot, but if you need to create Excel files (XLS or XLSX), then POI is the premier choice.
Anthony Alford
Greenhorn

Joined: Mar 24, 2009
Posts: 2
FYI, Jasper Reports uses the POI libraries to create XLS files.
Mike Pickard
Greenhorn

Joined: Feb 22, 2009
Posts: 3
Anthony Alford wrote:FYI, Jasper Reports uses the POI libraries to create XLS files.


I know. That's why I thought it was overkill...
Sudheerv Babu
Greenhorn

Joined: Aug 07, 2008
Posts: 5
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
Harish Sehgal
Greenhorn

Joined: Mar 04, 2008
Posts: 2
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Jakarta POI vs Jasper Reports.