UDF – TechITmore

Excel

Dynamically create and load user defined functions (UDF) for excel using Excel-DNA

Recently I faced a challenge of developing an excel plugin that can interact with a Java calculation server. The Java server was able to dynamically load JARs that contained all the calculations and make them available for invocation through a REST endpoints. If you wish to develop a Java server Read more…

By admin, 3 years3 years ago

Excel

Developing Excel Addin with User defined functions (UDF) and Ribbon using Excel DNA in .Net

We can easily develop cool XLA/XLAM addins using Excel’s native VBA editor, however, they are not enough in complex scenarios. In such scenarios, we would like to take full advantage of the .Net framework. Now there are several options when it comes to developing Excel addins using .Net and Visual Read more…

By admin, 4 years3 years ago