none
using ASP to export data from SQL database to excel as .XSL RRS feed

  • Question

  •  

    I am using
    Response.ContentType = "application/vnd.ms-excel"

     

    to export large amount of data into excel with ASP. It creates multiple worksheets. This is being used for daily production data. So the amount of worksheets adds up quick.

     

    Now, I am running into a problem. When ASP streams the data as .xsl into Excel, the file gets extremely big: over 7MB , however the same file when saved as Excel/Worksheet is about 1 MB.

     This takes up a lot of server resources to open such a big file and the users end up waiting for 7MB to download. Why is the .xsl so big when opened as Excel in the browser???

     

    How can I reduce this? Is there any other way of streaming data into excel with multiple worksheets that would not take up so much server resources?

    PLEASE HELP!!!!!

    Wednesday, October 24, 2007 4:51 PM