Re: excel problem in asp.net

Jack,

Save the excel spread*** 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" <jack79@xxxxxxxxxxx> wrote in message
news:u$QbMCGvFHA.3236@xxxxxxxxxxxxxxxxxxxxxxx
>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
>> > > >
>> > > >
>> > > >
>> > >
>> > >
>> > >
>> >
>> >
>> >
>
>


.

Loading