[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: Exporting data to an excel spreadsheet



I don't know how it will work with Struts, but there are some examples
in the code from Core Servlets book for using excel from JSPs:
http://archive.coreservlets.com/ 

Here is a snippet that actually works.

<%@ page contentType="application/vnd.ms-excel" %>
<%-- Note that there are tabs, not spaces, between columns. --%>
1997	1998	1999	2000	2001 (Anticipated)
12.3	13.4	14.5	15.6	16.7

HTH,
jeffrey


-----Original Message-----
From: Sharma Vedula [mailto:vedulasharma@yahoo.com] 
Sent: Tuesday, November 19, 2002 9:51 AM
To: ajug-members@ajug.org
Subject: Exporting data to an excel spreadsheet


I have a web application written using Struts 1.2. 
One of the pages displays a table of data.  I have a
button on it which when clicked need to export all
that data to a Excel spreadsheet.  I am a novice in
struts and would really appreciate any direction you
can give.  I have been looking at apache's POI, but do
not know how to implement it in my application.

Any suggestions will be greatly appreciated.

Thanks

Sharma

=====
Sharma Vedula
Ph: 770-642-9708 (Home)
    678-849-3741 (Cell)
1115 Lyndhurst Way
Roswell, GA 30075

__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com