Export to Excel

Discussion in 'Java' started by Sachin, Dec 6, 2005.

  1. Sachin

    Sachin Guest

    Is there a way to export results generated from a Servlet as a html
    table to a microsoft Excel sheet using Java ?
     
    Sachin, Dec 6, 2005
    #1
    1. Advertising

  2. Sachin

    IchBin Guest

    Sachin wrote:
    > Is there a way to export results generated from a Servlet as a html
    > table to a microsoft Excel sheet using Java ?
    >


    Think you want to look at Jakarta POI. It provides Java API's To Access
    Microsoft Format Files

    http://jakarta.apache.org/poi/

    Thanks in Advance...
    IchBin, Pocono Lake, Pa, USA
    http://weconsultants.servebeer.com/JHackerAppManager
    __________________________________________________________________________

    'If there is one, Knowledge is the "Fountain of Youth"'
    -William E. Taylor, Regular Guy (1952-)
     
    IchBin, Dec 6, 2005
    #2
    1. Advertising

  3. Sachin

    IchBin Guest

    IchBin wrote:
    > Sachin wrote:
    >> Is there a way to export results generated from a Servlet as a html
    >> table to a microsoft Excel sheet using Java ?
    >>

    >
    > Think you want to look at Jakarta POI. It provides Java API's To Access
    > Microsoft Format Files
    >
    > http://jakarta.apache.org/poi/
    >
    > Thanks in Advance...
    > IchBin, Pocono Lake, Pa, USA
    > http://weconsultants.servebeer.com/JHackerAppManager
    > __________________________________________________________________________
    >
    > 'If there is one, Knowledge is the "Fountain of Youth"'
    > -William E. Taylor, Regular Guy (1952-)


    Here are some articles you may be interested in

    http://www.javaworld.com/javaworld/javaqa/2002-05/01-qa-0503-excel3.html
    http://www.onjava.com/pub/a/onjava/2003/01/22/poi.html
    http://www.devx.com/Java/Article/17301
    http://programming.newsforge.com/article.pl?sid=04/10/21/1452220&tid=54







    --


    Thanks in Advance...
    IchBin, Pocono Lake, Pa, USA
    http://weconsultants.servebeer.com/JHackerAppManager
    __________________________________________________________________________

    'If there is one, Knowledge is the "Fountain of Youth"'
    -William E. Taylor, Regular Guy (1952-)
     
    IchBin, Dec 6, 2005
    #3
  4. Sachin

    Guest

    Many ways.
    1. Set the content type/disposition header like this
    Content-type: text/html
    Content-Disposition: attachment; filename.xls
    Since excel can open html contents this should work fine.

    2. The better way is to output the data in xml format using XSLT or
    directly from your servlet in MS-XML document format.

    3. Output/convert data in CSV format and save it with .csv extension.

    4. You can have a look at POI also.

    Amit :)
     
    , Dec 6, 2005
    #4
  5. Sachin wrote:
    > Is there a way to export results generated from a Servlet as a html
    > table to a microsoft Excel sheet using Java ?


    http://www.andykhan.com/jexcelapi/

    Richard
     
    Richard Wheeldon, Dec 6, 2005
    #5
  6. Sachin

    Roedy Green Guest

    On 6 Dec 2005 00:13:14 -0800, "Sachin" <> wrote,
    quoted or indirectly quoted someone who said :

    >Is there a way to export results generated from a Servlet as a html
    >table to a microsoft Excel sheet using Java ?


    see http://mindprod.com/jgloss/excel.html
    --
    Canadian Mind Products, Roedy Green.
    http://mindprod.com Java custom programming, consulting and coaching.
     
    Roedy Green, Dec 6, 2005
    #6
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?RGF2aWQgVmFsbGU=?=

    Invalid export DLL or export format

    =?Utf-8?B?RGF2aWQgVmFsbGU=?=, Oct 29, 2003, in forum: ASP .Net
    Replies:
    0
    Views:
    3,669
    =?Utf-8?B?RGF2aWQgVmFsbGU=?=
    Oct 29, 2003
  2. =?Utf-8?B?U3JpZGhhcg==?=

    using Microsoft Excel image for Export to Excel button

    =?Utf-8?B?U3JpZGhhcg==?=, Dec 9, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    3,164
    =?Utf-8?B?U3JpZGhhcg==?=
    Dec 9, 2005
  3. =?Utf-8?B?SGVtYW50IFNpcGFoaW1hbGFuaQ==?=

    Export to Excel (Default File Type - Excel)

    =?Utf-8?B?SGVtYW50IFNpcGFoaW1hbGFuaQ==?=, Apr 24, 2006, in forum: ASP .Net
    Replies:
    15
    Views:
    17,665
    syed hassan
    May 21, 2009
  4. Grey
    Replies:
    4
    Views:
    2,119
    Mark Rae [MVP]
    Oct 17, 2007
  5. Maarten Porters
    Replies:
    1
    Views:
    465
    Florian Gilcher
    Jul 28, 2008
Loading...

Share This Page