export sql query results to Excel

Discussion in 'ASP .Net' started by S. Justin Gengo, Nov 6, 2005.

  1. Dica,

    I have example code to do this on my website at:
    http://www.aboutfortunate.com?page=codelibrary

    Use the search box there to search for "export excel" and you'll have the
    code.

    --
    Sincerely,

    S. Justin Gengo, MCP
    Web Developer / Programmer

    www.aboutfortunate.com

    "Out of chaos comes order."
    Nietzsche
    "Dica" <> wrote in message
    news:...
    > is it possible to generate an Exel file showing the results of an sql
    > query
    > from an ASPX page?
    >
    >
    >
    S. Justin Gengo, Nov 6, 2005
    #1
    1. Advertising

  2. Hi Dear Dica,

    is it possible to generate an Exel file showing the results of an sql query
    from an ASPX page?

    Yes, Ofcourse;

    here is the link

    VB.Net
    =====

    HOW TO: Use ASP.NET to Query and Display Database Data in Excel by Using
    Visual Basic .NET
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    http://support.microsoft.com/default.aspx?scid=kb;en-us;308247

    C#
    ===

    HOW TO: Use ASP.NET to Query and Display Database Data in Excel by Using
    Visual C# .NET
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    http://support.microsoft.com/default.aspx?scid=kb;en-us;311194

    For Anything and Everything, Please Let Me Know.

    Bye
    Venkat_KL
    =?Utf-8?B?VmVua2F0X0tM?=, Nov 6, 2005
    #2
    1. Advertising

  3. S. Justin Gengo

    Dica Guest

    is it possible to generate an Exel file showing the results of an sql query
    from an ASPX page?
    Dica, Nov 6, 2005
    #3
  4. S. Justin Gengo

    PL Guest

    Problem with these solutions and the print htmlt able solution is that
    it is only good for very simple excel sheets that do not need to have
    multiple pages or formulas in them.

    There are commercial ASP.NET solutions for this, and I belive, if you have office
    installed on the server you can (at least you could in classic ASP) instatiate
    an Excel.Application object and operate on it.

    I would guess you need to wrap the com object to be able to do that in .NET

    PL.

    "Venkat_KL" <> skrev i meddelandet news:...
    > Hi Dear Dica,
    >
    > is it possible to generate an Exel file showing the results of an sql query
    > from an ASPX page?
    >
    > Yes, Ofcourse;
    >
    > here is the link
    >
    > VB.Net
    > =====
    >
    > HOW TO: Use ASP.NET to Query and Display Database Data in Excel by Using
    > Visual Basic .NET
    > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    >
    > http://support.microsoft.com/default.aspx?scid=kb;en-us;308247
    >
    > C#
    > ===
    >
    > HOW TO: Use ASP.NET to Query and Display Database Data in Excel by Using
    > Visual C# .NET
    > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    > http://support.microsoft.com/default.aspx?scid=kb;en-us;311194
    >
    > For Anything and Everything, Please Let Me Know.
    >
    > Bye
    > Venkat_KL
    PL, Nov 6, 2005
    #4
  5. S. Justin Gengo

    Dica Guest

    "Venkat_KL" <> wrote in message
    news:...
    > Hi Dear Dica,
    >
    > is it possible to generate an Exel file showing the results of an sql

    query
    > from an ASPX page?
    >
    > Yes, Ofcourse;
    >
    > here is the link
    >
    > VB.Net
    > =====
    >
    > HOW TO: Use ASP.NET to Query and Display Database Data in Excel by Using
    > Visual Basic .NET
    > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    >
    > http://support.microsoft.com/default.aspx?scid=kb;en-us;308247
    >
    > C#
    > ===
    >
    > HOW TO: Use ASP.NET to Query and Display Database Data in Excel by Using
    > Visual C# .NET
    > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    > http://support.microsoft.com/default.aspx?scid=kb;en-us;311194
    >
    > For Anything and Everything, Please Let Me Know.
    >
    > Bye
    > Venkat_KL


    perfect. thanks guys.
    Dica, Nov 6, 2005
    #5
    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. Anonymous
    Replies:
    0
    Views:
    1,442
    Anonymous
    Oct 13, 2005
  2. Chris McFarling

    Export SQL query results to text file

    Chris McFarling, Sep 16, 2008, in forum: ASP .Net
    Replies:
    3
    Views:
    8,683
    George
    Sep 17, 2008
  3. IluDeR
    Replies:
    0
    Views:
    240
    IluDeR
    Jan 21, 2004
  4. IluDeR
    Replies:
    0
    Views:
    231
    IluDeR
    Jan 21, 2004
  5. Replies:
    4
    Views:
    259
    Adrienne Boswell
    Feb 5, 2007
Loading...

Share This Page