Meaningless Drivel is fun!*
The moose likes Java in General and the fly likes create, read and write ms excel through j2ee( jsp, ejb, servlets) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "create, read and write ms excel through j2ee( jsp, ejb, servlets)" Watch "create, read and write ms excel through j2ee( jsp, ejb, servlets)" New topic
Author

create, read and write ms excel through j2ee( jsp, ejb, servlets)

Naadir Peterson
Ranch Hand

Joined: Sep 22, 2004
Posts: 37
Hi...

Can anyone tell me how to create,read and write to microsoft excel sheets...
I need to generate reports and graphs from a database to an excel spread sheet fast and effeciantly through a web application...

Are there any api's available... and is it feasible or a good idea to create reports through ms excel or should i conform to a third-party software?
I found a product called JReport - http://www.jinfonet.com/javareporting.htm
that looks quite interesting...

Please inform me what would be the most appropriate solution.

Thanks

The key to success is knowledge...
The key to knowledge is effort...
Karthikeyan Rajendraprasad
Ranch Hand

Joined: Apr 16, 2003
Posts: 70
for creating/reading/writing excel files you can go for jxl or Apache poi. For generating charts you can use jcharts. all are freewares and easy to use.
[ March 08, 2005: Message edited by: Karthikeyan Rajendraprasad ]

Karthikeyan<br />SCJP 1.4, SCWCD.
brad balmer
Ranch Hand

Joined: Mar 08, 2004
Posts: 57
You should also take a look at using displaytags:
http://displaytag.sourceforge.net/

It allows you to export a table directly to Excel.
Jan Rotthaus
Ranch Hand

Joined: Jun 23, 2004
Posts: 56
We used Jakarta POI to import an uploaded file into the database, and it was very simple! And - by the way - I like the meaning (Poor Obfuscation Implementation).


SCJP 1.4, SCJD, SCBCD 1.3, SCMAD 1.0
SCPBDA7, SCPBDP7, SCAPC8
OCUP Fundamental
David Plass
Greenhorn

Joined: Aug 10, 2004
Posts: 2
We used POI too, and it was pretty painless for creating XLS.
Ilja Preuss
author
Sheriff

Joined: Jul 11, 2001
Posts: 14112
Another option is to use the open office API. More heavyweight and less userfriendly, but also more powerfull, as far as I know.


The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
somkiat puisungnoen
Ranch Hand

Joined: Jul 04, 2003
Posts: 1312
Can anyone tell me how to create,read and write to microsoft excel sheets...


I'm create excel file in MS Excel and save as to html(copy to jsp file) file after set content type of jsp for display excel file type.

POI is good tool. and jxl api is easy to use for read/write excel file.


SCJA,SCJP,SCWCD,SCBCD,SCEA I
Java Developer, Thailand
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: create, read and write ms excel through j2ee( jsp, ejb, servlets)
 
Similar Threads
exporting information to MS excel
reading data from excel sheet through servlets in linux
Java reports in Excel/other formats
crystal report and java
creating excel file by servlet