Access denied error while using excel object
any body suggest me the solution for this
I am using excel object in my server side code. But, I am
getting Access denied error for the user asp.net . I gave
full permission for the Asp.net account on the directory
where I am running the application.Do I need to change any
security permission for excel?? Here is my code and the
exception that I am getting.
Excel.Application excel= new Excel.Application();
int rowIndex=1;
int colIndex=0;
ERROR
> --------
> Access is denied.
> 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.UnauthorizedAccessException:
> Access is denied.
>
> The ASP.NET process is not authorized to access the
> requested resource. For security reasons the default
> ASP.NET process identity is '{machinename}\ASPNET', which
> has limited privileges. Consider granting access rights to
> the resource to the ASP.NET process identity.
>
Source Error:
Line 1161: {
Line 1162:
Line 1163:Excel.Application excel= new Excel.Application();
Line 1164: int rowIndex=1;
Line 1165: int colIndex=0;
most intersting is that same code worked for 5-6 hours on the serve later error started
i did this also but colud not solve my problem still having that error
PLz help me
To grant ASP.NET write access to a file, right-click the
file in Explorer, choose "Properties" and select the
Security tab. Click "Add" to add the "{machinename}
\ASPNET" user. Highlight the ASP.NET account, and check
the Write box in the Allow column.
