Re: excel problem in asp.net

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" <EltonW@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:83037EDD-7B12-40EB-8E59-8B47A28FB791@xxxxxxxxxxxxxxxx
> 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.Work***
> >
> > xl.Workbooks.Add()
> >
> > xl.Visible = True
> >
> > xl = Nothing
> >
> >
> >
> > "Oleg Ogurok" <oleg@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:YFXWe.40205$h_1.34247@xxxxxxxxxxxxxxxxxxxxxxxx
> > >
> > > Launch "dcomcnfg" from Start -> Run and change security changes there
to
> > > allow user ASPNET to launch Excel.
> > >
> > > -Oleg.
> > >
> > >
> > > "jack" <jack79@xxxxxxxxxxx> wrote in message
> > > news:etezFP6uFHA.3720@xxxxxxxxxxxxxxxxxxxxxxx
> > > > 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
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >


.