How to convert jsp page to Excel format

Discussions

General J2EE: How to convert jsp page to Excel format

Bookmark and Share Get thread feed

  1. How to convert jsp page to Excel format (4 messages)

    • Posted by: Mreddy B
    • Posted on: April 19 2005 11:46 EDT
    I am display some report in jsp pagenow . I want to dispaly this report via Excel format.
    can any body give any idea?
    Reply to this

    Threaded Messages (4)

  2. Apache POI[ Go to top ]

    http://jakarta.apache.org/poi/hssf/index.html

    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.

    HTH,
    sv
    Reply to this Reply to original

  3. How to convert jsp page to Excel format[ Go to top ]

    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.
    Reply to this Reply to original

  4. Doesn't work on https[ Go to top ]

    Do you know how to make it work on https too?

    Reply to this Reply to original

  5. How to convert jsp page to Excel format[ Go to top ]

    Its fairly simple and can be done with minimum changes to your existing JSP. Take a look at this example on quicklyjava.com:

     

    http://www.quicklyjava.com/export-web-page-to-excel/

    Reply to this Reply to original