如何为Excel插件创建安装程序？ [英] how to create setup for excel addin?

问题描述

我使用vs2010在vb.net中创建了一个excel插件应用程序，该应用程序在IDE中运行时运行良好。现在，我想为应用程序创建一个安装程序，以在其他系统中安装相同的插件。我怎样才能做到这一点？我创建了一个安装项目，并添加了插件的dll并创建了安装文件。当我在其他计算机上安装它时，安装成功。但是，当我打开它时，我在Excel中看不到该插件。有人可以帮我吗？

I have a created an excel addin application in vb.net using vs2010.The application is working fine while running from IDE. Now I want to create a setup for the application to install the same addin in other system. How can I do this? I created a setup project and added the dll of the addin and created setup file. When I installed it in other machine, installation was succesful. However I could not see the addin in excel when i opened it. Can someone help me on this?

推荐答案

在可用加载项对话框中显示的Excel加载项列表为在Excel启动时重建。
它基于Excel内置加载项和第三方客户加载项。您有兴趣安装的第三方插件的位置在两个地方；每个用户和每个计算机位置。每台计算机的位置由PC上的所有帐户使用，并且位于<程序文件> Microsoft Office< Office版本>库中。每个用户位置位于<根驱动器：> \users\<用户名> \AppData\Roaming\Microsoft\AddIns。

The list of Excel Add-ins displayed in the "Available Add-Ins" dialog is rebuilt at Excel startup. It's based on Excel built-in add-ins and 3rd party customer add-ins. The locations of the 3rd party add-ins, the ones you are interested in installing, are in two places; per user and per machine locations. The per machine location is used by all accounts on the PC, and that's located in <program files>\Microsoft Office\<Office version>\Library. The per user location is at <root drive:>\users\<user name>\AppData\Roaming\Microsoft\AddIns.

如果您在每台计算机上安装，则用户将需要管理员权限才能在此处安装。

If you install in the per-machine location, then the user would need admin rights to install there.

还有第三个插件位置，即以前的插件手动加载并存储在用户的XLB设置文件中。 XLB文件是二进制文件，而不是安装程序可以触摸的文件。

There is also a 3rd addin location, that is previous addins that were manually loaded and stored in the user's XLB setting file. The XLB file is a binary file and not something that an installer would touch.

这篇关于如何为Excel插件创建安装程序？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！