By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,934 Members | 1,527 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,934 IT Pros & Developers. It's quick & easy.

excel problem in asp.net

P: n/a
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

Nov 19 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a

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

-Oleg.
"jack" <ja****@hotmail.com> wrote in message
news:et**************@TK2MSFTNGP14.phx.gbl...
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


Nov 19 '05 #2

P: n/a
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

"Oleg Ogurok" <ol**@ogurok.com.ihatespammers.co> wrote in message
news:YF*******************@fe56.usenetserver.com.. .

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

-Oleg.
"jack" <ja****@hotmail.com> wrote in message
news:et**************@TK2MSFTNGP14.phx.gbl...
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


Nov 19 '05 #3

P: n/a
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
"jack" <ja****@hotmail.com> wrote in message
news:uR**************@TK2MSFTNGP15.phx.gbl...
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

"Oleg Ogurok" <ol**@ogurok.com.ihatespammers.co> wrote in message
news:YF*******************@fe56.usenetserver.com.. .

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

-Oleg.
"jack" <ja****@hotmail.com> wrote in message
news:et**************@TK2MSFTNGP14.phx.gbl...
> 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
>
>
>



Nov 19 '05 #4

P: n/a
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" wrote:
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

"Oleg Ogurok" <ol**@ogurok.com.ihatespammers.co> wrote in message
news:YF*******************@fe56.usenetserver.com.. .

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

-Oleg.
"jack" <ja****@hotmail.com> wrote in message
news:et**************@TK2MSFTNGP14.phx.gbl...
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



Nov 19 '05 #5

P: n/a
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 ?
"Elton W" <El****@discussions.microsoft.com> wrote in message
news:83**********************************@microsof t.com...
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" wrote:
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

"Oleg Ogurok" <ol**@ogurok.com.ihatespammers.co> wrote in message
news:YF*******************@fe56.usenetserver.com.. .

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

-Oleg.
"jack" <ja****@hotmail.com> wrote in message
news:et**************@TK2MSFTNGP14.phx.gbl...
> 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
>
>
>


Nov 19 '05 #6

P: n/a
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
"jack" <ja****@hotmail.com> wrote in message
news:u$**************@TK2MSFTNGP14.phx.gbl...
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 ?
"Elton W" <El****@discussions.microsoft.com> wrote in message
news:83**********************************@microsof t.com...
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" wrote:
> 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
>
>
>
> "Oleg Ogurok" <ol**@ogurok.com.ihatespammers.co> wrote in message
> news:YF*******************@fe56.usenetserver.com.. .
> >
> > Launch "dcomcnfg" from Start -> Run and change security changes there to > > allow user ASPNET to launch Excel.
> >
> > -Oleg.
> >
> >
> > "jack" <ja****@hotmail.com> wrote in message
> > news:et**************@TK2MSFTNGP14.phx.gbl...
> > > 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
> > >
> > >
> > >
> >
> >
> >
>
>
>


Nov 19 '05 #7

P: n/a
On Sat, 17 Sep 2005 09:13:00 -0700, "jack" <ja****@hotmail.com> wrote:

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...b;en-us;257757
Paul
~~~~
Microsoft MVP (Visual Basic)
Nov 19 '05 #8

P: n/a
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
"jack" wrote:
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 ?
"Elton W" <El****@discussions.microsoft.com> wrote in message
news:83**********************************@microsof t.com...
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" wrote:
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

"Oleg Ogurok" <ol**@ogurok.com.ihatespammers.co> wrote in message
news:YF*******************@fe56.usenetserver.com.. .
>
> Launch "dcomcnfg" from Start -> Run and change security changes there to > allow user ASPNET to launch Excel.
>
> -Oleg.
>
>
> "jack" <ja****@hotmail.com> wrote in message
> news:et**************@TK2MSFTNGP14.phx.gbl...
> > 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
> >
> >
> >
>
>
>


Nov 19 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.