Hi,I am receiving the following exception when using the xlApp.Workbooks.Add() method with ASP.NET and Office 2007. Server Error in '/ExcelTest'
Microsoft Office Excel cannot open or save any more
documents because there is not enough available memory or disk space.
. To make more memory available, close workbooks or programs you no longer
. To free disk space, delete files you no longer need from the disk you are
unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the
error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException:
Microsoft Office Excel cannot open or save any more documents because
there is not enough available memory or disk space. There is plenty of disk space and memory on the servers. What's really strange is that it works OK when I specify a template with the Add method: .Workbooks.Add(Server.MapPath("~") & "\ReportTemplate.xls")So that's a workaround anyway...Below is a small sample I'm using to try and debug this problem.In a new web project, add a reference to Microsoft Excel 12.0 Object Library, add a button named btnGenerateReport, a label named lblStatus, and a Hyperlink named lnkExcelReport to Default.aspx and paste the
View Complete Post