如何为Excel创建GUI加载项? [英] How do I create a GUI add in for excel?
问题描述
我已经在Google上做了一些修改，但是我仍然找不到Visual Studio中的哪个项目.我想为Excel创建一个GUI加载项，例如，具有Windows窗体的功能区上的停靠窗口.这在Visual Studio中是什么项目?我已经尝试了Excel add in，但是我不知道它是否具有我要寻找的GUI组件.
I've done some mucking around on Google but I still can't find what project this would be in Visual Studio. I want to create a GUI add in for Excel, for example a dock window on a ribbon with a windows form. What project would this be in Visual Studio? I have tried Excel add in but I don't know if this has the GUI component I'm looking for.
推荐答案
为此，Microsoft为您提供了"Visual Studio Office工具"(VSTO)，请参见此处以获取更多信息.
Microsoft offers you "Visual Studio Tools for Office" (VSTO) for this purpose, see here for more information.
http://en.wikipedia.org/wiki/Visual_Studio_Tools_for_Office#External_links
但是，如果您想要更轻巧的解决方案，并且仅在Excel中需要它，我建议您看一下Excel DNA
But if you want a more lightweight solution, and you need it only for Excel, I suggest you have a look at Excel DNA
这是免费软件，已经成熟，甚至可以与Visual Studio的Express版本一起使用，并且与VSTO不同，您可以将每个受支持的.NET版本与每个Excel版本和所需的每个Visual Studio版本结合起来.我自己创建了一些带有Excel DNA的Excel加载项，我很喜欢.
This is freeware, mature, works even with the Express editions of Visual Studio and different from VSTO you can combine every supported .NET version with every Excel version and every Visual Studio version you like. I have created some Excel addins with Excel DNA on my own, and I love it.
这篇关于如何为Excel创建GUI加载项?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
