在IIS 6.0上使用OLEDB创建大型Excel工作表时出现问题 [英] Problem creating large excel sheets with OLEDB on IIS 6.0
问题描述
我有一个在IIS 6.0 Windows 2003 SP2上运行的ASP.NET 2.0 Web应用程序.
在应用程序中是一个页面，用户可以在其中获取按点传递的数据，然后单击Excel Sheets. Excel表是用OLEDB创建的，代码在Vb中包含的dll文件中.
问题在于，当它的数据集非常大时，excel表格中没有数据(标题除外).
该代码在开发环境中可以正常工作.而且只要excel表的大小不超过672Kb.
我还制作了一个用于小型测试的小Windows应用程序，并且创建具有大量数据的excel工作表并将其放置在服务器上的同一目录中没有问题.
而且上传或下载大文件也没有问题.
因此，当进程在IIS上下文中运行时，该问题可能会受到某种限制.
有谁知道可能是什么问题吗?
关于
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
推荐答案
它是作为Excel 2007创建的.当应用程序在开发环境中运行时，大文件或多行都没有问题.
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.
请检查此链接
http://www.experts-exchange.com/Microsoft/Development/.NET/Q_22918485. html [ ^ ]
Please check this link
http://www.experts-exchange.com/Microsoft/Development/.NET/Q_22918485.html[^]
之所以会发生这种情况，是因为一个请求中要传输的数据量
因为iis 6可能有局限性，所以我只是一个想法
可能是原因
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
这篇关于在IIS 6.0上使用OLEDB创建大型Excel工作表时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
