Re: excel problem in asp.net

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" <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
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
>
>
>
.