Export to Excel

[Sachin]

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

 

[IchBin]

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-)

 

[IchBin]

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-)

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







--


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-)

 

[amitkch]

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

 

[Richard Wheeldon]

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

 

[Roedy Green]

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