Discussions

Web tier: servlets, JSP, Web frameworks: generate excel output from database ?

Bookmark and Share Get thread feed

  1. generate excel output from database ? (3 messages)

    • Posted by: majid abdel
    • Posted on: May 08 2002 14:54 EDT
    I need to output an excel report from a database, is there any taglib that
    can I use for that or an example of a servlet .
    thanks



    Reply to this

    Threaded Messages (3)

  2. generate excel output from database ?[ Go to top ]

    set the content type of the response object to Excel's MIME type. i personally use

    response.setContentType("application/x-msexcel");

    but I've seen an another valid content type.

    you can lazily output your data to an HTML table and let excel try to parse it. a better idea is to create a sample spreadsheet in Excel, export it to XML, and view the source to see how Excel handles functions and tabular data.

    then you can generate the XML yourself and it will be ready to use by Excel!
    Reply to this Reply to original

  3. generate excel output from database ?[ Go to top ]

    could you please give me a small example ?
    thanks
    Reply to this Reply to original

  4. generate excel output from database ?[ Go to top ]

    See Excel taglib in Coldtags suite:
    www.servletsuite.com/jsp.htm
    Reply to this Reply to original