Hacker News new | ask | show | jobs
by emodendroket 4282 days ago
So could you do UDFs with this?
1 comments

No but have a look at https://github.com/ericremoreynolds/excelpython for UDFs.
Cool. The problem with all these big "VBA replacements" (and don't get me wrong, I've done both VBA and VSTO and the latter is more pleasant to work with) is that they never seem to provide replacements for UDFs, which is probably the #1 reason you'd want to use VBA in the first place.
Excel-DNA is a nice open source project that lets you write XLLs in .NET http://exceldna.codeplex.com
also http://www.pyxll.com if you want a solution that embeds python and doesn't use a COM server