在Excel中创建UDF使用VSTO [英] Creating UDF with VSTO in Excel

问题描述

我知道我可以在简单情况如下细节做到这一点： http://geekswithblogs.net/Denis/archive/2007/01/03 /102623.aspx

I know how I can do this for the simple case as details here: http://geekswithblogs.net/Denis/archive/2007/01/03/102623.aspx

不过，我想要做的是，当在Excel中，选择我的分类我希望能够动态填充在运行时函数列表。

But what I'm trying to do is when my category is selected in Excel I want to be able to dynamically populate the function list at run-time.

由于是，它使用的DLL类的所有公共职能填充。有没有挂钩到用于填充该列表中的事件，并告诉它使用的一些方式？或者，也许注入一些code到DLL动态，在这种情况下，我可以插入一堆的公共职能到DLL在运行时等有我想要的功能列表中

As is, it's populated using all public function in the category DLL. Is there some way of hooking into the event that populates this list and telling it what to use? Or maybe injecting some code into the DLL dynamically, in this case I could insert a bunch of public functions into the DLL at run time and so have what I want in the function list

推荐答案

通过ExcelDna - 的http：// WWW codeplex.com / exceldna - 你可以明确地在运行时寄存器的功能。不过，我不认为这是很容易知道是显示的功能列表时，所以你可能有一个菜单项或东西填充的列表中。

With ExcelDna - http://www.codeplex.com/exceldna - you can explicitly register the functions at runtime. However, I don't think it is easy to know when the function list is displayed, so you might have to have a menu items or something that fills the list.

这篇关于在Excel中创建UDF使用VSTO的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！