Excel

Blog posts discussion the use of Excel with .NET libraries.

Porting Excel to .NET

In previous blog posts, we demonstrated calling NMath from within Excel (C#, Visual Basic). Another common use case is replacing an Excel spreadsheet with an equivalent .NET application. Today, we are releasing .NET code to make this task much easier. We have created a library of Excel extensions for NMath that work just like the built-in Excel mathematical and statistical functions. They work wi...
Read More

Advanced Curve Fitting using Excel and NMath

In recent blog posts, we have discussed how to call CenterSpace's Libraries from Excel. In his March 2010 blog post, CenterSpace's Ken Baldwin demonstrated how to replicate Excel's existing Trendline functions using C# and NMath. In this post, we will demonstrate the advanced curve fitting functions available in the CenterSpace libraries that could be easily be integrated into Excel analysis wor...
Read More

Using C# and ExcelDNA to call .NET Libraries

In my last post, I demonstrated calling NMath from Excel using ExcelDNA and Visual Basic (VB) code. In this blog post, we will duplicate that functionality using C# instead of Visual Basic. In addition we will use the functionality of NMath to enabled the marshaling of data between Excel and NMath, and provide some additional code examples. The outcome of these blog articles should illustrate...
Read More

Calling External .NET Libraries from Excel

There are many circumstances where you may need to access an external library of functions or routines from Excel.  For example, if you need a complex function such as fitting data to a surface, or portfolio optimization, that is not natively available in Excel.  There also may be a need to protect proprietary calculations by using user defined functions to process algorithms in a black box manner...
Read More

Excel Trendlines

We are sometimes asked how to reproduce the various Excel Trendline types in NMath, including printing out the form of the equation and the R2 value (coefficient of determination). Excel offers these trend types: Linear Trendline Logarithmic Trendline Exponential Trendline Power Trendline Polynomial Trendline Moving Average Trendline These can all be easily computed using NMath. Let'...
Read More
Top