Calling Excel Function from C# using Excel.Interop

Hello All,
I am converting an excel file to a C# program. Some of the functions are not in the .net math library. So I want to use the Excel function using excel interop from my code without opening excel or even displaying a spreadsheet on screen. I just want the formula library.

Namespace is probably Microsoft.Office.Interop.Excel;

NORMDIST(x,mean,standard_dev,cumulative)
   X   is the value for which you want the distribution.
   Mean   is the arithmetic mean of the distribution.
   Standard_dev   is the standard deviation of the distribution

MEDIAN(number1,number2,...)
Number1, number2, ...   are 1 to 255 numbers for which you want the median.

I have never used interop before and found info on how to build an add-in for excel to call c# functions from excel (which is pretty cool btw). The thing is, I would like to use some of these function without having to re-develop them. Excel will be installed on the local machine, so no prob for deployment.




Start Free Trial