We help IT Professionals succeed at work.

Excel export not happening for more than 4 mb data in ASP and vbscript.

Medium Priority
854 Views
Last Modified: 2012-05-07
Hello Experts,
Here is the scenario:
I have a website in ASP/ vbscript, IIS 6.0
I run a query in Oracle 10g and get the data in an array on the front end (ASP).
The array is then used to export data in excel and shown to users.
It works fine for excel size less than 4 mb but if the excel size increases to more than 4 mb I get the error: Page cannot be displayed.
I was wondering if there is some setting that i need to do for allowing the export of data to excel which is more than 4 mb.
Any suggestions are welcomed.
Thank You.
Comment
Watch Question

Commented:
Have you tried these type of setting? Note, figures are just example numbers.
<%
Session.Timeout=30
Server.ScriptTimeout=90
Response.Expires=0
%>

Open in new window

Author

Commented:
Hi TOBZZZ-
Thanks for looking into this, but its not a time out issue. But I will give this a try too.
 
Also check if the data you are exporting is exceeding excel's limit of 65536 rows in a worksheet

Author

Commented:
The max number of records is just 2000. It will never exceed to more than that. So excel's limit is never reached.
If the data results in more than 65536 rows when exported to excel, you may have to partition the data into multiple excel sheets. Excel can only take a maximum of 65536 rows in a worksheet and 256 worksheets in a workbook.

Commented:
if you just write it to screen, not create as an excel doc, does it still time out? If it was me, I would run the query and display on screen to eliminate if it is writing to excel that's the problem.

Commented:
sorry, not time out, but fail...... does it still fail?
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Hello lharrispv,
That is exactly what i was looking for. My Sys Admin also pointed me towards the same.
I have set the AspBufferingLimit="26214400" --> 25 MB in metabase.xml file at c:\Windows\System32\Inetsrv. The default was 4 MB. AspBufferingLimit is used to set the Response limit.
Also, AspMaxRequestEntityAllowed  is actualy used to set the upload file limit to the server i.e. Request limit.
Thank You.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.