I am using ASP to stream data from SQL database into Excel for client side viewing. File Size TOO BIG HELP! RRS feed

  • Question


    I am using

    Response.ContentType = "application/"

    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 .xml 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 .xml 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!!!!!

    Monday, October 22, 2007 11:19 PM