Using Excel Functions from C#

[briby]

Hi there
I'm a relative new comer to .net, I have a project that is taking some calculations that are done in a spreadsheet and coding them in c#. No problem I'll just use the Math library I thought ... Except no NORMSDIST and no NORMSINV.

I believe you can access these Excel functions somehow(?!) but am not sure what steps I would need to go through to do this. I would prefer to actually have the code for the functions in c# itself, as I didn't know the consequences of accessing the excel stuff (this functionality is going to be accessed via a web service - if this makes a difference)

Thankyou in advance

Brian

 

[Coolstep]

Dear Brian,
I couldn't find the functions NORMSDIST and NORMSINV and to use them I had to use a library at Code Project called interop.Excel it's very usefull. Hope it helps u.

 

[briby]

Thanks for that - I'd found some stuff previously todo with calling the worksheetfunctions but that given me a steer on how to actually get the reference.

I'm still hoping to find some code that'll do it without Excel as obv. I'd rather not have to install it on the web server.

Cheers