VS2010开发Excel2007插件以及制作打包安装程序

最近刚做了个Excel2007的插件玩玩,顺便记录一下自己的开发过程;

刚开始新建一个"Excel2007外接程序",这样开发结果是制作了一个office加载项,通过Excel自己的功能加载项中可以将开发的*.dll加载到菜单中,但是有个问题是制作安装包的时候,无法加载成功,可能是权限的问题,结果自己也没有找到解决方法.

后来用了另外一种方法,同样是在vs2010上面有个"其他项目类型"->"扩展性"->"共享的外接程序":

这个会自动创建一个插件的注册项目和打包安装项目,借鉴微软的相关文档:http://support.microsoft.com/default.aspx?scid=kb;en-us;Q302901.

根据上面文档参考,打包的安装程序可以直接注册到系统中,至于注册表方面不需要自己去考虑了,系统给你做好.

主要注册代码如下:

    /// <summary>    ///   The object for implementing an Add-in.    /// </summary>    /// <seealso class='IDTExtensibility2' />    [GuidAttribute("E6DACA4D-DE5F-4016-862A-696DA731F77C"), ProgId("DateExcelAddIn.Connect")]    public class Connect : Object, Extensibility.IDTExtensibility2    {        /// <summary>        /// 定义一个功能按钮，时间插件        /// </summary>        private Office.CommandBarButton dateButton;        /// <summary>        ///Implements the constructor for the Add-in object.        ///Place your initialization code within this method.        /// </summary>        public Connect()        {        }        /// <summary>        ///      Implements the OnConnection method of the IDTExtensibility2 interface.        ///      Receives notification that the Add-in is being loaded.        /// </summary>        /// <param term='application'>        ///      Root object of the host application.        /// </param>        /// <param term='connectMode'>        ///      Describes how the Add-in is being loaded.        /// </param>        /// <param term='addInInst'>        ///      Object representing this Add-in.        /// </param>        /// <seealso class='IDTExtensibility2' />        public void OnConnection(object application, Extensibility.ext_ConnectMode connectMode, object addInInst, ref System.Array custom)        {            applicationObject = application;            addInInstance = addInInst;            if (connectMode != ext_ConnectMode.ext_cm_Startup)            {                OnStartupComplete(ref custom);            }        }        /// <summary>        ///     Implements the OnDisconnection method of the IDTExtensibility2 interface.        ///     Receives notification that the Add-in is being unloaded.        /// </summary>        /// <param term='disconnectMode'>        ///      Describes how the Add-in is being unloaded.        /// </param>        /// <param term='custom'>        ///      Array of parameters that are host application specific.        /// </param>        /// <seealso class='IDTExtensibility2' />        public void OnDisconnection(Extensibility.ext_DisconnectMode disconnectMode, ref System.Array custom)        {            if (disconnectMode != ext_DisconnectMode.ext_dm_HostShutdown)            {                OnBeginShutdown(ref custom);            }            applicationObject = null;        }        /// <summary>        ///      Implements the OnAddInsUpdate method of the IDTExtensibility2 interface.        ///      Receives notification that the collection of Add-ins has changed.        /// </summary>        /// <param term='custom'>        ///      Array of parameters that are host application specific.        /// </param>        /// <seealso class='IDTExtensibility2' />        public void OnAddInsUpdate(ref System.Array custom)        {        }        /// <summary>        ///      Implements the OnStartupComplete method of the IDTExtensibility2 interface.        ///      Receives notification that the host application has completed loading.        /// </summary>        /// <param term='custom'>        ///      Array of parameters that are host application specific.        /// </param>        /// <seealso class='IDTExtensibility2' />        public void OnStartupComplete(ref System.Array custom)        {            ///定义菜单集合            Office.CommandBars oCommandBars;            Office.CommandBar oStandardBar;            try            {                oCommandBars = applicationObject.GetType().InvokeMember("CommandBars", System.Reflection.BindingFlags.GetProperty, null, applicationObject, null) as Office.CommandBars;            }            catch (Exception)            {                object oActiveExplorer;                oActiveExplorer = applicationObject.GetType().InvokeMember("ActiveExplorer", BindingFlags.GetProperty, null, applicationObject, null);                oCommandBars = oActiveExplorer.GetType().InvokeMember("CommandBars", BindingFlags.GetProperty, null, oActiveExplorer, null) as Office.CommandBars;            }            try            {                oStandardBar = oCommandBars["Standard"];            }            catch (Exception)            {                oStandardBar = oCommandBars["Database"];            }            try            {                dateButton = (Office.CommandBarButton)oStandardBar.Controls["CaculateDate"];            }            catch (Exception)            {                object omissing = Missing.Value;                dateButton = (Office.CommandBarButton)oStandardBar.Controls.Add(1, omissing, omissing, omissing, omissing);                dateButton.Caption = "计算时间";                dateButton.Style = Office.MsoButtonStyle.msoButtonCaption;            }            dateButton.Tag = "CaculateDate";            dateButton.OnAction = "!<DateExcelAddIn.Connect>";            dateButton.Visible = true;            dateButton.Click += new Office._CommandBarButtonEvents_ClickEventHandler(dateButton_Click);            oStandardBar = null;            oCommandBars = null;        }        /// <summary>        ///      Implements the OnBeginShutdown method of the IDTExtensibility2 interface.        ///      Receives notification that the host application is being unloaded.        /// </summary>        /// <param term='custom'>        ///      Array of parameters that are host application specific.        /// </param>        /// <seealso class='IDTExtensibility2' />        public void OnBeginShutdown(ref System.Array custom)        {            object omissing = System.Reflection.Missing.Value;            dateButton.Delete(omissing);            dateButton = null;        }        void dateButton_Click(Office.CommandBarButton Ctrl, ref bool CancelDefault)        {            //点击之后可以选择两列,然后,计算结果显示;            using (RibbonConfig configForm = new RibbonConfig())            {                if (DialogResult.OK == configForm.ShowDialog())                {                    //计算数值;                    DateExcel.GetSelectedCells((Excel.Application)applicationObject);                }            }        }        private object applicationObject;        private object addInInstance;    }

以上作为记录.