excel problem in asp.net

[jack]

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.

ASP.NET is not authorized to access the requested resource. Consider
granting access rights to the resource to the ASP.NET request identity.
ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or
Network Service on IIS 6) that is used if the application is not
impersonating. If the application is impersonating via <identity
impersonate="true"/>, the identity will be the anonymous user (typically
IUSR_MACHINENAME) or the authenticated request user.

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
appropriate user or group. Highlight the ASP.NET account, and check the
boxes for the desired access.

Source Error:

Line 29:
Line 30: Private Sub Button1_Click(ByVal sender As System.Object, ByVal
e As System.EventArgs) Handles Button1.Click
Line 31: Dim abc As New Excel.Application
Line 32: End Sub
Line 33: End Class

I did add aspnet user for excel.exe, but the error still happen.
Any idea ? Thanks

 

[Oleg Ogurok]

Launch "dcomcnfg" from Start -> Run and change security changes there to
allow user ASPNET to launch Excel.

-Oleg.

 

[jack]

thanks, it helps, but why this code below doesn't display excel on my screen
?

Dim xl As New Excel.Application

Dim xb As Excel.Workbook

Dim xs As Excel.Worksheet

xl.Workbooks.Add()

xl.Visible = True

xl = Nothing

 

[S. Justin Gengo]

Jack,

The code you are using creates an excel workbook file in memory as an object
that you can work with. Everything you're showing here happens in memory.
You haven't given any command to save the file you are creating or to then
open that file with excel.

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche

 

[Guest]

Hi Jack,

In your code, it's impossible to display excel on your screen. Your code
runs on web server, how to do you expect it is shown on client-side. You
should write excel content to browser, e.g. using Response.Write.

BTW, it's not good idea to use Office automation on web server.

HTH

Elton Wang

 

[jack]

I appreciate your answers,
btw, how to give instruction to open excel on remote computer ? what happens
if remote client has different version of excel ? do you think it will good
idea if we embedded excel object in asp.net form ?

 

[S. Justin Gengo]

Jack,

Save the excel spreadsheet you create as an excel file in some directory
accessible on your web site, then give the user a link to that new file.
Clicking the link will give the user the option to open or save the file.

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche

 

[Paul Clement]

¤ 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.
¤
¤ ASP.NET is not authorized to access the requested resource. Consider
¤ granting access rights to the resource to the ASP.NET request identity.
¤ ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or
¤ Network Service on IIS 6) that is used if the application is not
¤ impersonating. If the application is impersonating via <identity
¤ impersonate="true"/>, the identity will be the anonymous user (typically
¤ IUSR_MACHINENAME) or the authenticated request user.
¤
¤ 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
¤ appropriate user or group. Highlight the ASP.NET account, and check the
¤ boxes for the desired access.
¤
¤ Source Error:
¤
¤ Line 29:
¤ Line 30: Private Sub Button1_Click(ByVal sender As System.Object, ByVal
¤ e As System.EventArgs) Handles Button1.Click
¤ Line 31: Dim abc As New Excel.Application
¤ Line 32: End Sub
¤ Line 33: End Class
¤
¤ I did add aspnet user for excel.exe, but the error still happen.
¤ Any idea ? Thanks

Something to keep in mind:

INFO: Considerations for Server-Side Automation of Office
http://support.microsoft.com/default.aspx?scid=kb;en-us;257757


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Guest]

Hi Jack,

As I mentioned it's not good idea to use Office Automation on server-side.
Microsoft does not currently recommend, and does not support, Automation of
Microsoft Office applications from any unattended, non-interactive client
application or component (including ASP, DCOM, and NT Services), because
Office may exhibit unstable behavior and/or deadlock when run in this
environment. In our practice, it did cause troubles.

HTH

Elton Wang