VSTO外接程序项目只用1个文件实现Ribbon CustomUI和CustomTaskpane定制【C#版】

VSTO中的自定义功能区和自定义任务窗格需要用到各种命名空间、添加所需文件，才能实现。后来我发现可以把所有代码都写在ThisAddin.cs这个默认文件中。

大家可以在Visual Studio中创建一个外接程序项目，然后把ThisAddin.cs中的代码整体替换为下面我贴的这个代码。然后启动调试，就可以看到自定义功能区和任务窗格了。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml.Linq;
using Excel = Microsoft.Office.Interop.Excel;
using Office = Microsoft.Office.Core;
using Microsoft.Office.Tools.Excel;

namespace ExcelAddInTemplate_CS
{
    public partial class ThisAddIn
    {
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            Module1.CreateCTP();
        }

        private void ThisAddIn_Shutdown(object sender, System.EventArgs e)
        {
            Module1.DisposeCTP();
        }
        protected override Office.IRibbonExtensibility CreateRibbonExtensibilityObject()
        {
            return new Ribbon1();
        }
        #region VSTO generated code

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InternalStartup()
        {
            this.Startup += new System.EventHandler(ThisAddIn_Startup);
            this.Shutdown += new System.EventHandler(ThisAddIn_Shutdown);
        }
        
        #endregion
    }
    [System.Runtime.InteropServices.ComVisible(true)]
    public class Ribbon1:Microsoft.Office.Core.IRibbonExtensibility
    {
        public Office.IRibbonUI R;
        string Office.IRibbonExtensibility.GetCustomUI(string RibbonID)
        {
            string xml= @"<customUI xmlns='http://schemas.microsoft.com/office/2009/07/customui' onLoad='OnLoad'>
    <ribbon startFromScratch='false'>
        <tabs>
            <tab id='Tab1' label='RibbonXmlEditor'>
                <group id='Group1' label='Author:ryueifu'>
                    <button id='Button1' label='CTP' imageMso='C' onAction='Button1_Click'/>
                    <button id='Button2' label='UnLoad' imageMso='U' onAction='Button2_Click'/>
                </group>
            </tab>
        </tabs>
    </ribbon>
</customUI>";
            return xml;
        }
        public void OnLoad(Office.IRibbonUI ribbon)
        {
            R = ribbon;
            R.ActivateTab(ControlID: "Tab1");
        }
        public void Button1_Click(Office.IRibbonControl control)
        {
            Module1.ctp.Visible = !Module1.ctp.Visible;
        }
        public void Button2_Click(Office.IRibbonControl control)
        {
            Office.COMAddIn ThisCOM = Globals.ThisAddIn.Application.COMAddIns.Item("ExcelAddInTemplate_CS");
            ThisCOM.Connect = false;
        }

    }
    public static class Module1
    {
        public static System.Windows.Forms.UserControl uc;
        public static Microsoft.Office.Tools.CustomTaskPane ctp;
        public static void CreateCTP()
        {
            uc = new System.Windows.Forms.UserControl();
            ctp = Globals.ThisAddIn.CustomTaskPanes.Add(control: uc, title: "CTP");
            ctp.DockPosition = Office.MsoCTPDockPosition.msoCTPDockPositionRight;
            ctp.Visible = true;
        }
        public static void DisposeCTP()
        {
            ctp.Dispose();
        }
    }
}