Only 49 hours left in the trailboss' kickstarter!

New rewards and stretch goals. CLICK HERE!



  • Post Reply Bookmark Topic Watch Topic
  • New Topic

how to generate excel report from servlet  RSS feed

 
Raghuveer Rawat
Ranch Hand
Posts: 102
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi
I want to generate excel report from servlet/jsp.
if someone has done this before will pass this information to me.
Thanking you
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36393
453
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can output a tab delimitted text string to produce a basic Excel report. If you want to do anything more complicated, you need to use a framework such as Apache's POI
 
Wayne L Johnson
Ranch Hand
Posts: 399
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
An alternative to POI is Java Excel API, which is an open source API for reading and writing Excel files. For basic operations you probably can't go wrong with either one.
 
steve souza
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
By changing the content type any HTML table will become a spreadsheet.

steve - http://www.jamonapi.com - a simple, fast, free, open source performance tuning and salability testing api
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!