General J2EE: How to convert jsp page to Excel format
I am display some report in jsp pagenow . I want to dispaly this report via Excel format.
- Posted by: Mreddy B
- Posted on: April 19 2005 11:46 EDT
can any body give any idea?
Have an alternate view that builds an excel doc and return it in binary format (with appropriate mimetype).
A cheaper solution:
Use a csv format that can be imported directly into excel.
Just try to set the content type like this at the top of your page.
<%@ page contentType="application/vnd.ms-excel" %>
Newer Excel versions have the ability to understand HTML tables.
Do you know how to make it work on https too?
Its fairly simple and can be done with minimum changes to your existing JSP. Take a look at this example on quicklyjava.com: