GeeCON Prague 2014*
The moose likes Servlets and the fly likes how to generate excel report from servlet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » Servlets
Bookmark "how to generate excel report from servlet" Watch "how to generate excel report from servlet" New topic
Author

how to generate excel report from servlet

Raghuveer Rawat
Ranch Hand

Joined: Apr 03, 2003
Posts: 102
hi
I want to generate excel report from servlet/jsp.
if someone has done this before will pass this information to me.
Thanking you


Raghuveer Rawat<br />SCJP2
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30580
    
154

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


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Wayne L Johnson
Ranch Hand

Joined: Sep 03, 2003
Posts: 399
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

Joined: Jun 26, 2002
Posts: 861
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


http://www.jamonapi.com/ - a fast, free open source performance tuning api.
JavaRanch Performance FAQ
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: how to generate excel report from servlet