There is a "simple" way to do this. Look for the MIME type for excel
worksheets and set the content type to that MIME type.
Later you can put HTML tables and excel will interpret its content like
cells.
For example:
<%@ page contentType="application/excel.... or similar" %>
<html>
<body>
<table>
<tr>
<td>cell1</td>
</td>cell2</td>
</tr>
<tr>....</tr>
</table>
</body>
</html>
This will open the excel in your browser (iexplorer)
If you don't want the excel to be opened you can put the next HTTP header:
content-disposition: attachment
> >> --- Smita Kotnis <[EMAIL PROTECTED]> wrote:
> >>> Hi All,
> >>> In my application I have a requirement of
> >>> creating an excel file from a JSP page. The data
> >>> would be in a couple of vectors and based on those
> >>> values multi columned excel sheet is to be
> >>> generated. How to do this?? any suggestions? Thanks
> >>> in anticipation.
> >>>
> >>> Regards
> >>> Smita
> >>> -------------------------------------------------
> >>> This mail helped a tree grow. Know more at
> >>> http://green.sify.com
> >>>
> >>> Take the shortest route to success!
> >>> Click here to know how http://education.sify.com
> >>>
> >>>
> >>
========================================================================
> >> ===
> >>> To unsubscribe: mailto [EMAIL PROTECTED] with
> >>> body: "signoff JSP-INTEREST".
> >>> For digest: mailto [EMAIL PROTECTED] with body:
> >>> "set JSP-INTEREST DIGEST".
> >>> Some relevant FAQs on JSP/Servlets can be found at:
> >>>
> >>> http://archives.java.sun.com/jsp-interest.html
> >>> http://java.sun.com/products/jsp/faq.html
> >>> http://www.esperanto.org.nz/jsp/jspfaq.jsp
> >>> http://www.jguru.com/faq/index.jsp
> >>> http://www.jspinsider.com
> >>
> >>
> >> =====
> >> luv,
> >> sandy
> >>
> >> __________________________________________________
> >> Do You Yahoo!?
> >> Send FREE Valentine eCards with Yahoo! Greetings!
> >> http://greetings.yahoo.com
> >>
> >>
========================================================================
> >> ===
> >> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> >> JSP-INTEREST".
> >> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> >> DIGEST".
> >> Some relevant FAQs on JSP/Servlets can be found at:
> >>
> >> http://archives.java.sun.com/jsp-interest.html
> >> http://java.sun.com/products/jsp/faq.html
> >> http://www.esperanto.org.nz/jsp/jspfaq.jsp
> >> http://www.jguru.com/faq/index.jsp
> >> http://www.jspinsider.com
> >>
> >>
> >
> > -------------------------------------------------
> > This mail helped a tree grow. Know more at http://green.sify.com
> >
> > Take the shortest route to success!
> > Click here to know how http://education.sify.com
> >
> >
=========================================================================
> > ==
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> > JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> > DIGEST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> > http://archives.java.sun.com/jsp-interest.html
> > http://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.jsp
> > http://www.jguru.com/faq/index.jsp
> > http://www.jspinsider.com
> >
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://archives.java.sun.com/jsp-interest.html
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.jsp
> http://www.jguru.com/faq/index.jsp
> http://www.jspinsider.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
