Problem creating large excel sheets with OLEDB on IIS 6.0

Question

0.00/5 (No votes)

See more:

I have an ASP.NET 2.0 Web application running on IIS 6.0 Windows 2003 SP2.

In the application is a page where users can get data delivered by point and click in Excel Sheets. The excel sheet is create with OLEDB an the code is in an includede dll file made in Vb.

The problem is when its a very large dataset, there is no data in the excel sheet, excepts for the headlines.

The code works fine in the development enviroment. And long as the excel sheet don't getting bigger than 672Kb.

I have also made an little windows application for a small test, and there was no problem with creating an excel sheet with a huge amount of data an place it in the same directory on the server.

And there is no problems with uploading or downloading large files.

So the problem may some kind of limitation when the process is running in the context of the IIS.

Is there anybody who have any idea what the problem might be?

Regards

Posted 12-Dec-10 20:26pm

kgn_100@hotmail.com

Add a Solution

Comments

Wild-Programmer 13-Dec-10 2:35am

Which version of Excel are you using? MS Office 2000 had a limitation of only 65535 rows. MS Office 2007 breaks this barrier.

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

kgn_100@hotmail.com · Answer 1 · 2010-12-12T20:44:00

Solution 1

It is created as Excel 2007. And when the application runs in the development enviroment, there is no problems with large files or many rows.

Posted 12-Dec-10 20:44pm

kgn_100@hotmail.com

Wild-Programmer · Answer 2 · 2010-12-12T20:44:00

Solution 2

Please check this link

http://www.experts-exchange.com/Microsoft/Development/.NET/Q_22918485.html[^]

Posted 12-Dec-10 20:44pm

Wild-Programmer

Rajmendra*Nh · Answer 3 · 2010-12-12T20:50:00

Solution 3

this may be happen because of Amount of data to traveled in one request
because iis 6 can have the limitations i have just an idea
that can be cause of that

Posted 12-Dec-10 20:50pm

Rajmendra*Nh

senguptaamlan · Answer 4 · 2010-12-12T20:51:00

You can take another approach....as you are using web application its strongly recommended that if a process is resource hungry or consumes a great amount of resource then process it asynchronously. So when the user clicks on the page maintain a queue in DB or MSMQ, Create a Windows Service that reads the queue and generates the excel files asynchronously, after that create a track of the processed messages so that you can inform the user whether their request has been processed or not.

kgn_100@hotmail.com · Answer 5 · 2010-12-12T20:51:00

Solution 4

Sorry can't read experts exchange, I'm not member :(

Posted 12-Dec-10 20:51pm

kgn_100@hotmail.com

Comments

Toniyo Jackson 13-Dec-10 2:54am

Don't write your comments here. You have add comment button below all answers. so write your comments below the appropriate answer.

kgn_100@hotmail.com 13-Dec-10 3:38am

Ohh... Sorry. I'm new to this so I havent seen that... But thanks, I'll rember that in the future.

Problem creating large excel sheets with OLEDB on IIS 6.0

5 solutions

Solution 1

Solution 2

Solution 3

Solution 5

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us