Question

Paolo Magalini on Wed, 24 Apr 2019 04:38:31


Good Morning, this days i am trying out VSTO but for example i saw that writing UDF (user defined functions) in Visual Studio are not that easy tasks as i thought...

I write scientific programs and run numerical simulations completely in VBA right now...I wonder what is the best option if i wish to use Excel as a frontend for data input output and let .NET programs to be the calculation engine (and get rid of VBA). I wish to keep all my code in one place and i would like to use visual studio as the IDE.

I am aware that on market there are several ".NET Spreadsheet" and i don't know if Microsoft has something officially supported.

Thanks, Paolo