Using Excel API in .NET

[Chris Jackson]

> I have an ASP.NET app that does some calculations.

> I want to use the built in functions i n Excel e.g Price
> etc and other various financial functions rather than
> write them.
> So all I want to do is use teh Excel API / Object Library
> in .NET.
>
> Do I need Excel installed on my web server to do this, as
> I won't be using the Excel Application. I just want to
> use the API?

Yes. The API is merely the entry way into the application.

> In terms of performance, would this pose an issue with
> loads of users accessing my site?

Yes. Depending on what you are doing, you could very well end up launching
excel.exe with every web request. This uses a lot of system resources.

Also keep security in mind - your web server will now have all of the
vulnerabilities of ASP.NET, IIS, AND Excel. You get more attack surface when
you install more software.

If you know the formula that you want to use, and it's a small number, you
may just want to code it yourself. You may also want to investigate the
Office web controls.

--
Chris Jackson
Software Engineer
Microsoft MVP - Windows XP
Windows XP Associate Expert
--

[Natty Gur]

Hi,

In addition to Kens answer try to check if math.net (.net library) got
the calculation your looking for :
[url]http://sourceforge.net/projects/nmath[/url]

Natty Gur, CTO
Dao2Com Ltd.
34th Elkalay st. Raanana
Israel , 43000
Phone Numbers:
Office: +972-(0)9-7740261
Fax: +972-(0)9-7740261
Mobile: +972-(0)58-888377


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!