Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old March 24th, 2004, 10:58 AM
Registered User
 
Join Date: Mar 2004
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default ASP to Excel

I am exporting an ASP page(a report) to Excel. I use the response.contenttype thing and everything works fine. Sometimes when i have lots of rows, over 10,000 it takes a long time to open. The file downloads fast but when i try to open the excel file it takes real long. The file size is about 2mb but i have other excel files that are 4 megs and have 40,000 rows but they open up in about a second while the excel that i exported from asp is only 2 megs and takes like 10 minutes.

Has anyone run into this problem

I have one table in the page

Thanks,

Luke

  #2 (permalink)  
Old March 24th, 2004, 12:44 PM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

Transferring 2 megs over HTTP is not going to be very fast. When you open an XLS file locally, it just has to read from disk. When ASP is generating it, it's going to take some time to generate and transfer.
  #3 (permalink)  
Old March 24th, 2004, 12:46 PM
Registered User
 
Join Date: Mar 2004
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I save the file first then open it locally. And it takes about 5 to 10 minutes to open up.



Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP to Excel BUT show Excel grid lines mat41 Classic ASP Basics 8 May 31st, 2009 05:56 PM
asp to excel darkhalf Classic ASP Basics 2 September 17th, 2008 07:31 AM
ASP - Excel to Database cancer10 Classic ASP Databases 4 March 18th, 2007 11:07 PM
Excel Hyperlinks in ASP JoseLuisR Classic ASP Professional 3 December 26th, 2006 12:44 AM
ASP to Excel - excel output formatting issue mat41 Classic ASP Professional 0 August 13th, 2006 06:41 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.