Export to Excel

Thread view:

Enable EMail Alerts

Start New Thread

Sachin - 06 Dec 2005 08:13 GMT

Is there a way to export results generated from a Servlet as a html
table to a microsoft Excel sheet using Java ?

Reply to this Message

IchBin - 06 Dec 2005 08:56 GMT

> Is there a way to export results generated from a Servlet as a html
> table to a microsoft Excel sheet using Java ?

Think you want to look at Jakarta POI. It provides Java API's To Access
Microsoft Format Files

http://jakarta.apache.org/poi/

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA
http://weconsultants.servebeer.com/JHackerAppManager
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

Reply to this Message

IchBin - 06 Dec 2005 09:14 GMT

>> Is there a way to export results generated from a Servlet as a html
>> table to a microsoft Excel sheet using Java ?
[quoted text clipped - 11 lines]
> 'If there is one, Knowledge is the "Fountain of Youth"'
> -William E. Taylor, Regular Guy (1952-)

Here are some articles you may be interested in

http://www.javaworld.com/javaworld/javaqa/2002-05/01-qa-0503-excel3.html
http://www.onjava.com/pub/a/onjava/2003/01/22/poi.html
http://www.devx.com/Java/Article/17301
http://programming.newsforge.com/article.pl?sid=04/10/21/1452220&tid=54

Signature

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA
http://weconsultants.servebeer.com/JHackerAppManager
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

Reply to this Message

amitkch@gmail.com - 06 Dec 2005 10:25 GMT

Many ways.
1. Set the content type/disposition header like this
Content-type: text/html
Content-Disposition: attachment; filename.xls
Since excel can open html contents this should work fine.

2. The better way is to output the data in xml format using XSLT or
directly from your servlet in MS-XML document format.

3. Output/convert data in CSV format and save it with .csv extension.

4. You can have a look at POI also.

Amit :-)

Reply to this Message

Richard Wheeldon - 06 Dec 2005 18:55 GMT

> Is there a way to export results generated from a Servlet as a html
> table to a microsoft Excel sheet using Java ?

http://www.andykhan.com/jexcelapi/

Richard

Reply to this Message

Roedy Green - 06 Dec 2005 21:04 GMT

>Is there a way to export results generated from a Servlet as a html
>table to a microsoft Excel sheet using Java ?

see http://mindprod.com/jgloss/excel.html

Signature

Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.

Reply to this Message