Office COM add-in 开发(一)

     Office 的 add-in 分为两类,一类是application add-in,一类是 COM add-in. COM add-in 是一个进程内的COM server,需要实现 IDTExensibility2 接口 。该接口定义在Msaddndr.dll (Microsoft add-in designer type library) 中,该接口有五个成员函数。

    1. OnConnection(IDispatch *pApplication, AddInDesignerObjects::ext_ConnectMode  ConnectMode, IDispatch *pAddInInst, SAFEARRAY ** custom )
        当 add-in 被加载的时候,这个函数会被触发。 如果函数返回成功,那么add-in会继续加载,如果返回失败,则add-in 会停止加载,add-in 对象会被删除。
  •            IDispatch * pApplication: reference to the host application object.
  •            AddInDesignerObjects::ext_ConnectMode: 
                                 - ext_cm_AfterStartup: The add-in is started by the end user from the COM Add-ins dialog box.
                                 - ext_cm_CommandLine: The add-in is connected from the command line. Note that this does not apply to building COM add-ins for Office applications.
                                - ext_cm_External: The add-in is connected by an external application through Automation. Note that this does not apply to building COM add-ins for Office applications.
                                 - ext_cm_Startup: The add-in is started by the host at application startup. This behavior is controlled by a setting in the registry.
  •     IDispatch *pAddInInst: A reference to the COMAddIn object that refers to this add-in in the  COMAddIns collection for the host application.  
  •     SAFEARRAY ** : An array of Variant type values that can hold user-defined data.
   2. OnDisconnection(AddInDesignerObjects::ext_DisconnectMode  RemoveMode, SAFEARRAY ** custom )
      当 add-in 被卸载的时候,这个函数会被触发。
  •      AddInDesignerObjects::ext_DisconnectMode RemoveMode: 
      - ext_dm_HostShutdown: The add-in is disconnected when the host application closes.
         - ext_dm_UserClosed: The add-in is disconnected by the end user or an Automation controller.


 3. OnStartupComplete (SAFEARRAY ** custom ):add-in 加载结束的时候会调用
     OnBeginShutdown (SAFEARRAY ** custom ) : 开始卸载 add-in 的时候会调

    COM add-in 除了普通COM 的注册的过程,还会在:HKEY_CURRENT_USER\Software\Microsoft\Office\<OfficeApp>\Addins\<ProgID> 注册。在这个键(key)下面,有一个属性 LoadBehavior 是用来定义 add-in 被加载的方式。
  • 0 = Disconnect - Is not loaded.
  • 1 = Connected - Is loaded.
  • 2 = Bootload - Load on application startup.
  • 8 = DemandLoad - Load only when requested by user.
  • 16 = ConnectFirstTime - Load only once (on next startup).
  • The typical value specified is 0x03 (Connected | Bootload). 
1、Office2000 下内部COM插件的编程实现.................................................................................2 1.1、版权声明..........................................................................................................................2 1.2、内容详情..........................................................................................................................2 2、用VC6.0 编写Word插件..........................................................................................................11 2.1、版权声明........................................................................................................................11 2.2、内容详情........................................................................................................................11 3、探索 Word 2007 开发.............................................................................................................19 3.1、版权声明........................................................................................................................19 3.2、内容详情........................................................................................................................19 3.2.1 我的博客...............................................................................................................19 3.2.2 扩展 Ribbon.........................................................................................................28 3.2.3 管理侧栏...............................................................................................................43 3.2.4 上传图片...............................................................................................................49 3.2.5 部署插件...............................................................................................................56 4、用VC6.0 编写Word插件(Office2007 篇).................................................................................66 4.1、版权声明........................................................................................................................66 4.2、内容详情........................................................................................................................66 5、Microsoft Word 语法高亮插件(v1.2) ................................................................................70 5.1、版权声明........................................................................................................................70 5.2、内容详情........................................................................................................................70 6、VSTO学习笔记........................................................................................................................75 6.1、版权声明........................................................................................................................75 6.2、内容详情........................................................................................................................75 6.2.1 VSTO概述.............................................................................................................75 6.2.2 Excel对象模型.......................................................................................................89 6.2.3 开发Office 2010 64 位COM加载项...................................................................101 6.2.4 从SharePoint 2010 中下载文件.........................................................................117 6.2.5 批量编辑Excel 2010 x64....................................................................................123 6.2.6 在 Excel 2010 中使用RDLC报表.....................................................................131 7、Excel 二次开发系列..............................................................................................................137 7.1、版权声明......................................................................................................................137 7.2、内容详情......................................................................................................................137 7.2.1 Excel 编成模型...................................................................................................137 7.2.2 Excel 常用操作(创建、打开、读取、写入)...............................................139 7.2.3 创建Excel二次开发环境....................................................................................142 7.2.4 操作一个已经存在Excel....................................................................................143 7.2.5 插件开发系列操作.............................................................................................145 7.2.6 引用Excel模板....................................................................................................172 7.2.7 报表服务基础.....................................................................................................174 7.2.8 报表服务实例.....................................................................................................178
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值