«

Hi,

I have an excel worksheet with a lot of calculations which i would like to
incapsulate in a webservice. The scenario is that the webservice opens the
worksheet (by opening excel) fills in an couple of fields, lets excel
compute some values and send these values to the callee of the webservice.
Can i get this working? Is there a possibility not to envoke an excel
application object for each call but reuse the excell application object
with locking? This because of performance. Has anybody have any experience
with using office from a webservice and the performance penalties?

Many thanks in advance,

Bar

Danger Will Robinson - warning warning. Alian technology approach
commencing. Warning.

Seriously, the answer is "don't". Excel does not make a good stateless
implementation, and has all kinds of icky "current user" and "logged in
user" requirements. The best you can do is try and get a web service that
runs as a user account (not a machine account) to use the Excel automation
interface to do calculations. It's messy - with VS.net, you need to call
COM objects - and the performance/lag is going to be problematic.

Top that off with a new instance of your spreadsheet being spun up for each
web method request, and you lose all of the interactivity that you expect
from COM automation of a stateful object like Excel.

You're better off enabling DCOM and using your spreadsheet remote.

--------------------
>Reply-To: "Bar" <>
>From: "Bar" <>
>Subject: Using excel in a webservice
>Date: Mon, 21 Mar 2005 14:38:35 +0100
>Lines: 16
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <>
>Newsgroups: microsoft.public.dotnet.framework.aspnet.webservic es
>NNTP-Posting-Host: ip503db89a.speed.planet.nl 80.61.184.154
>Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGP08.phx.gbl!TK2MSFTNGP1
2.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet.webservic es:28727
>X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webservic es
>
>Hi,
>
>I have an excel worksheet with a lot of calculations which i would like to
>incapsulate in a webservice. The scenario is that the webservice opens the
>worksheet (by opening excel) fills in an couple of fields, lets excel
>compute some values and send these values to the callee of the webservice.
>Can i get this working? Is there a possibility not to envoke an excel
>application object for each call but reuse the excell application object
>with locking? This because of performance. Has anybody have any experience
>with using office from a webservice and the performance penalties?
>
>Many thanks in advance,
>
>Bar
>
>
>

Hi Dan,

> Alian technology approach
Ahh, Sometimes people say i look like ET. So this is why -

Let me elaborate on this. I have a lot of calculations in an excel worksheet
depending on 4 inputvariables which as a result gives two variables back. I
would like to use this calculations in my ASP.NET webapplication without
duplicating all the calculations in C#. So not wanting to install Excel on
my webserver i came up with this solution to use a webservice to remote
excel from another appserver. If i dont misunderstand you i am better off
using DCOM remoting in my ASP.NET web application to perform Excel
calculations from this appserver then using a webservice? In other words is
DCOM - ASP.NET combination giving me a better option to solve the
statefullnes and user requirements of Excel?

Thanks in advance,

Bar



"Dan Rogers" <> wrote in message
news:...
> Danger Will Robinson - warning warning. Alian technology approach
> commencing. Warning.
>
> Seriously, the answer is "don't". Excel does not make a good stateless
> implementation, and has all kinds of icky "current user" and "logged in
> user" requirements. The best you can do is try and get a web service that
> runs as a user account (not a machine account) to use the Excel automation
> interface to do calculations. It's messy - with VS.net, you need to call
> COM objects - and the performance/lag is going to be problematic.
>
> Top that off with a new instance of your spreadsheet being spun up for
> each
> web method request, and you lose all of the interactivity that you expect
> from COM automation of a stateful object like Excel.
>
> You're better off enabling DCOM and using your spreadsheet remote.
>
> --------------------
>>Reply-To: "Bar" <>
>>From: "Bar" <>
>>Subject: Using excel in a webservice
>>Date: Mon, 21 Mar 2005 14:38:35 +0100
>>Lines: 16
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>X-RFC2646: Format=Flowed; Original
>>Message-ID: <>
>>Newsgroups: microsoft.public.dotnet.framework.aspnet.webservic es
>>NNTP-Posting-Host: ip503db89a.speed.planet.nl 80.61.184.154
>>Path:
> TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGP08.phx.gbl!TK2MSFTNGP1
> 2.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.dotnet.framework.aspnet.webservic es:28727
>>X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webservic es
>>
>>Hi,
>>
>>I have an excel worksheet with a lot of calculations which i would like to
>>incapsulate in a webservice. The scenario is that the webservice opens the
>>worksheet (by opening excel) fills in an couple of fields, lets excel
>>compute some values and send these values to the callee of the webservice.
>>Can i get this working? Is there a possibility not to envoke an excel
>>application object for each call but reuse the excell application object
>>with locking? This because of performance. Has anybody have any experience
>>with using office from a webservice and the performance penalties?
>>
>>Many thanks in advance,
>>
>>Bar
>>
>>
>>
>

Adding to what Dan just said, you could try a third-party "calculation
engine" to achieve the same thing. There is one from Infragistics:

http://www.infragistics.com/Products...eFeatures.aspx

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com


"Dan Rogers" <> wrote in message
news:...
> Danger Will Robinson - warning warning. Alian technology approach
> commencing. Warning.
>
> Seriously, the answer is "don't". Excel does not make a good stateless
> implementation, and has all kinds of icky "current user" and "logged in
> user" requirements. The best you can do is try and get a web service that
> runs as a user account (not a machine account) to use the Excel automation
> interface to do calculations. It's messy - with VS.net, you need to call
> COM objects - and the performance/lag is going to be problematic.
>
> Top that off with a new instance of your spreadsheet being spun up for
each
> web method request, and you lose all of the interactivity that you expect
> from COM automation of a stateful object like Excel.
>
> You're better off enabling DCOM and using your spreadsheet remote.
>
> --------------------
> >Reply-To: "Bar" <>
> >From: "Bar" <>
> >Subject: Using excel in a webservice
> >Date: Mon, 21 Mar 2005 14:38:35 +0100
> >Lines: 16
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
> >X-RFC2646: Format=Flowed; Original
> >Message-ID: <>
> >Newsgroups: microsoft.public.dotnet.framework.aspnet.webservic es
> >NNTP-Posting-Host: ip503db89a.speed.planet.nl 80.61.184.154
> >Path:
>
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGP08.phx.gbl!TK2MSFTNGP1
> 2.phx.gbl
> >Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.dotnet.framework.aspnet.webservic es:28727
> >X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.webservic es
> >
> >Hi,
> >
> >I have an excel worksheet with a lot of calculations which i would like
to
> >incapsulate in a webservice. The scenario is that the webservice opens
the
> >worksheet (by opening excel) fills in an couple of fields, lets excel
> >compute some values and send these values to the callee of the
webservice.
> >Can i get this working? Is there a possibility not to envoke an excel
> >application object for each call but reuse the excell application object
> >with locking? This because of performance. Has anybody have any
experience
> >with using office from a webservice and the performance penalties?
> >
> >Many thanks in advance,
> >
> >Bar
> >
> >
> >
>