COMException (0x800a03ec): Microsoft Excel cannot access the
HI, I m getting the error when i tried to generate the excel file dynamically.I tried lot of solution but nothing works for me,
Issue:
Server Error in '/abc' Application.
--------------------------------------------------------------------------------
Microsoft Excel cannot access the file 'D:\Excel_11082014_170234.xlsx'. There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.
Description: An 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 Excel cannot access the file 'D:\Excel_11082014_170234.xlsx'. There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[COMException (0x800a03ec): Microsoft Excel cannot access the file 'D:\Excel_11082014_170234.xlsx'. There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.]
Pages_ReportingSch_ReportingSchListingView.getExcelSheetForDashboard(Int32 firmRptSchItemID) +900
Pages_ReportingSch_ReportingSchListingView.dlReportingScheduleDetails_OnItemCommand(Object sender, DataListCommandEventArgs e) +584
System.Web.UI.WebControls.DataList.OnBubbleEvent(Object source, EventArgs e) +63
System.Web.UI.WebControls.DataListItem.OnBubbleEvent(Object source, EventArgs e) +164
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +52
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3707
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1022
we have windows server 2008 R2 and office 2010 and IIS 7.5
solution I tried:
1. create a "Desktop" folder in system32 and syswow 64.
2. assigned full permission to the folder ( application is running under domain account).
3. set the domain account permission on DcomConfig microsoft excel application.
Please help me.
Thanks for help.