Mega Code Archive

 

Categories / C# Tutorial / Windows

 

Excel workbook event handlers

using System; using Excel; using System.Reflection; public class MainClass {   public static AppEvents_WorkbookBeforeCloseEventHandler Event_BeforeBookClose;   public static DocEvents_ChangeEventHandler Event_ChangeEvent;   public static void Main(string[] args)   {     Application excelApp = new ApplicationClass();     Workbook MyWorkbook = excelApp.Workbooks.Add(Missing.Value);     MyWorkbook.Windows.get_Item(1).Caption = "Using Delegates";     Worksheet MyWorksheet1 = (Worksheet)MyWorkbook.Worksheets.get_Item(1);     Worksheet MyWorksheet2 = (Worksheet)MyWorkbook.Worksheets.get_Item(2);     Worksheet MyWorksheet3 = (Worksheet)MyWorkbook.Worksheets.get_Item(3);     MyWorksheet1.Activate();     Event_BeforeBookClose = new AppEvents_WorkbookBeforeCloseEventHandler(BeforeBookClose);     excelApp.WorkbookBeforeClose += Event_BeforeBookClose;     Event_ChangeEvent = new DocEvents_ChangeEventHandler(CellChange);     MyWorksheet1.Change += Event_ChangeEvent;     MyWorksheet2.Change += Event_ChangeEvent;     MyWorksheet3.Change += Event_ChangeEvent;     excelApp.Visible = true;     excelApp.UserControl = true;   }   private static void CellChange(Range Target)   {     MessageBox.Show("cell changed");   }   private static void BeforeBookClose(Workbook MyWorkbook, ref bool Cancel)   {     MessageBox.Show("before closing a workbook");   } }