wood burning stoves
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

how to generate excel report from servlet

Raghuveer Rawat
Ranch Hand

Joined: Apr 03, 2003
Posts: 102
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

Joined: May 26, 2003
Posts: 33102

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

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, 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: 862
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
I agree. Here's the link: http://aspose.com/file-tools
subject: how to generate excel report from servlet
It's not a secret anymore!