用VSTO給EXCEL添加右鍵菜單項

歐陽家百創(chuàng)編如何用VSTO給EXCEL添加右鍵菜單項歐陽家百(2021.03.07)用VSTO操縱EXCEL使用C#語言開發(fā)的添加的右鍵菜單下直的確有“MyTest"—項，但是點擊卻不能進入OnCancelRelate_ClickEventHandler函數(shù)請叵)有誰知道為什么？？代碼如下//刪掉所有名為DEL_SUB」TEM_STR的菜單項Microsoft.Office.Core.CommandBar cellBar =Globals.ThisWorkbook.Application.CommandBars[Hceir,];Microsoft.Office.Core.CommandBai-Controlsbars=cellBar.Controls;Microsoft.Office.Core.CommandBarControl newCtrl =bars.Add(Microsoft.Office.Core.MsoControlType.msoControlButton,missing,missing,missing,true);//newCtrl.Caption=DEL_SUB_ITEM_STR;Microsoft.Office.Core.CommandBarButtonnewBtn=newCtrlasMicrosoft.Office.Core.CommandBarButton;newBtn.Tag=nMyTestM;newBtn.Caption="MyTest";newBtn.Faceld=0163;歐陽家百創(chuàng)編歐陽家百創(chuàng)編newBtn.StyleMicrosoft.Office.Core.MsoButtonStyle.msoButtonCaption;newBtn.Click += newMicrosoft.Office.Core._CommandBarButtonEvents_ClickEventHandler(OnCancelRelate_ClickEventHandler);檢查你添加的右鍵菜單項的類型newBtn.StyleMicrosoft.Office.Core.MsoButtonStyle.msoButtonCaption;這句不要估計就行了以下是添加按鈕，并且添加事件的實例，請LZ參考。。。新建excel-addin程序。1、 添加引用usingOffice=Microsoft.Office.Core;usingSystem.Collections;2、 聲明對象privateExcel.ApplicationAppExcel;privateOffice.CommandBarButtonbtnCalc;歐陽家百創(chuàng)編歐陽家百創(chuàng)編添加代碼〃宿主啟動時執(zhí)行?privatevoidThisAddIn_Startup(objectsender,System.EventArgse){AppExcel=Application;AddToolBar();}4、 以下是AddToolBar()方法的實現(xiàn)〃添加工具欄privatevoidAddToolBar(){Office.CommandBarsbars=AppExcel.CommandBars;if(bars==null)return;foreach(Office.CommandBarbarinbars){if(bar.Name.ToLower().Trim()=="mzbar"){bar.Delete();})Office.CommandBar mzBar =AppExcel.CommandBars.AddC'mzBar",1,null,null);if(mzBar!=null){btnCalc =(Office.CommandBarButton)mzBar.Controls.Add(Office.MsoControlType.msoControlButton,missing,missing,1,true);if(btnCalc!=null){歐陽家百創(chuàng)編btnCalc.Caption=”計算(&C)“；btnCalc.Style =Office.MsoButtonStyle.msoButtonlconAndCaption;btnCalc.TooltipText=”計算"；btnCalc.Faceld=3277;btnCalc.Click += newMicrosoft.Office.Core._CommandBarButtonEvents_ClickEventHandler(btnCalc_Click);}mzBar.Visible=true;}}4、以下是btnCalc_Click事件的實現(xiàn)voidbtnCalc_Click(Microsoft.Office.Core.CommandBarButtonCtrl