How to convert jsp page to Excel format

Discussions

General J2EE: How to convert jsp page to Excel format

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

    I am display some report in jsp pagenow . I want to dispaly this report via Excel format.
    can any body give any idea?

    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
  3. 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.
  4. Doesn't work on https[ Go to top ]

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

  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/