开发者

Microsoft Office Interop Excel 12.0 not working in IIS 7

开发者 https://www.devze.com 2022-12-21 09:01 出处:网络
I am creating a pivot table excel sheet in my ASP .NET web application using Microsoft Office Interop Excel 12.0 components. It is creating the excel file correctly, when i run it from my Visual Studi

I am creating a pivot table excel sheet in my ASP .NET web application using Microsoft Office Interop Excel 12.0 components. It is creating the excel file correctly, when i run it from my Visual Studio 2008 in Debug/Release mode.

But when i deploy the solution in IIS 7, first i got some permission issues, which i resolved by giving permission in the DCOMCNFG file. Now i am getting the following error, when trying to open the Excel file:

Microsoft Office Excel cannot open or save any more documents because there is not enough available memor开发者_如何学Pythony or disk space. • To make more memory available, close workbooks or programs you no longer need. • To free disk space, delete files you no longer need from the disk you are saving to.

These are the code which i used to open and close the excel application object

        xlApp.Visible = true;
        xlApp.UserControl = true;

        oSheet = null;
        oWB = null;
        xlApp.Quit();
        xlApp=null;


Please give up such an approach as soon as possible and consider Microsoft official suggestions,

http://support.microsoft.com/kb/257757

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号