Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Naadir Peterson
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
brad balmer
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).
 
David Plass
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We used POI too, and it was pretty painless for creating XLS.
 
Ilja Preuss
author
Sheriff
Posts: 14112
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Another option is to use the open office API. More heavyweight and less userfriendly, but also more powerfull, as far as I know.
 
somkiat puisungnoen
Ranch Hand
Posts: 1312
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic