asp & excel

Discussion in 'ASP General' started by bob, Sep 11, 2004.

  1. bob

    bob Guest

    Hi All,

    I've an asp page which brings back a query and displays it in a table. The
    query takes around 30 seconds. Once the page displays they will have an
    option to send it to excel. From the examples I've seen they all require the
    query to be re-ran again in asp (i.e. server side scripting) and as it takes
    30 seconds to start with I want to try and take out the repeat of the query.
    Does anyone know of any way you can do this in asp by passing the already
    executed table to asp or via any other method?

    Many thanks,
    Rob
    bob, Sep 11, 2004
    #1
    1. Advertising

  2. "bob" <> wrote in message
    news:chusjb$oot$...
    > Hi All,
    >
    > I've an asp page which brings back a query and displays it in a table.
    > The query takes around 30 seconds. Once the page displays they will have
    > an option to send it to excel. From the examples I've seen they all
    > require the query to be re-ran again in asp (i.e. server side scripting)
    > and as it takes 30 seconds to start with I want to try and take out the
    > repeat of the query. Does anyone know of any way you can do this in asp by
    > passing the already executed table to asp or via any other method?


    Depending on how much data is returned, I guess you could write the HTML
    table to a session variable.

    --
    Tom Kaminski IIS MVP
    http://www.microsoft.com/windowsserver2003/community/centers/iis/
    http://mvp.support.microsoft.com/
    http://www.iisfaq.com/
    http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
    http://www.tryiis.com
    Tom Kaminski [MVP], Sep 13, 2004
    #2
    1. Advertising

  3. bob

    M Bishop Guest

    We return the recordset as a response.write and use script to load excel and
    populate the spreadsheet...

    -mike


    "Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
    news:ci43u3$...
    > "bob" <> wrote in message
    > news:chusjb$oot$...
    > > Hi All,
    > >
    > > I've an asp page which brings back a query and displays it in a table.
    > > The query takes around 30 seconds. Once the page displays they will have
    > > an option to send it to excel. From the examples I've seen they all
    > > require the query to be re-ran again in asp (i.e. server side scripting)
    > > and as it takes 30 seconds to start with I want to try and take out the
    > > repeat of the query. Does anyone know of any way you can do this in asp

    by
    > > passing the already executed table to asp or via any other method?

    >
    > Depending on how much data is returned, I guess you could write the HTML
    > table to a session variable.
    >
    > --
    > Tom Kaminski IIS MVP
    > http://www.microsoft.com/windowsserver2003/community/centers/iis/
    > http://mvp.support.microsoft.com/
    > http://www.iisfaq.com/
    > http://www.iistoolshed.com/ - tools, scripts, and utilities for running

    IIS
    > http://www.tryiis.com
    >
    >
    M Bishop, Sep 17, 2004
    #3
    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. Anonieko
    Replies:
    2
    Views:
    7,308
    JackStraw73
    Feb 12, 2008
  2. Robbe Morris [C# MVP]

    asp.net extracting excel charts from an Excel file

    Robbe Morris [C# MVP], Dec 15, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    471
    Robbe Morris [C# MVP]
    Dec 15, 2006
  3. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,496
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
  4. Grey
    Replies:
    4
    Views:
    1,966
    Mark Rae [MVP]
    Oct 17, 2007
  5. fniles
    Replies:
    6
    Views:
    646
    Karl E. Peterson
    Apr 27, 2009
Loading...

Share This Page