public ExcelCallBack(Excel.Application app) { app.AfterCalculate += App_AfterCalculate1; app.NewWorkbook += App_NewWorkbook1; app.ProtectedViewWindowActivate += App_ProtectedViewWindowActivate; app.ProtectedViewWindowBeforeClose += App_ProtectedViewWindowBeforeClose; app.ProtectedViewWindowBeforeEdit += App_ProtectedViewWindowBeforeEdit; app.ProtectedViewWindowDeactivate += App_ProtectedViewWindowDeactivate; app.ProtectedViewWindowOpen += App_ProtectedViewWindowOpen; app.ProtectedViewWindowResize += App_ProtectedViewWindowResize; app.SheetActivate += App_SheetActivate; app.SheetBeforeDelete += App_SheetBeforeDelete; app.SheetBeforeDoubleClick += App_SheetBeforeDoubleClick; app.SheetBeforeRightClick += App_SheetBeforeRightClick; app.SheetCalculate += App_SheetCalculate; app.SheetChange += App_SheetChange; app.SheetDeactivate += App_SheetDeactivate; app.SheetFollowHyperlink += App_SheetFollowHyperlink; app.SheetLensGalleryRenderComplete += App_SheetLensGalleryRenderComplete; app.SheetPivotTableAfterValueChange += App_SheetPivotTableAfterValueChange; app.SheetPivotTableBeforeAllocateChanges += App_SheetPivotTableBeforeAllocateChanges; app.SheetPivotTableBeforeCommitChanges += App_SheetPivotTableBeforeCommitChanges; app.SheetPivotTableBeforeDiscardChanges += App_SheetPivotTableBeforeDiscardChanges; app.SheetPivotTableUpdate += App_SheetPivotTableUpdate; app.SheetSelectionChange += App_SheetSelectionChange; app.SheetTableUpdate += App_SheetTableUpdate; app.WindowActivate += App_WindowActivate; app.WindowDeactivate += App_WindowDeactivate; app.WindowResize += App_WindowResize; app.WorkbookActivate += App_WorkbookActivate; app.WorkbookAddinInstall += App_WorkbookAddinInstall; app.WorkbookAddinUninstall += App_WorkbookAddinUninstall; app.WorkbookAfterSave += App_WorkbookAfterSave; app.WorkbookAfterXmlExport += App_WorkbookAfterXmlExport; app.WorkbookAfterXmlImport += App_WorkbookAfterXmlImport; app.WorkbookBeforeClose += App_WorkbookBeforeClose; app.WorkbookBeforePrint += App_WorkbookBeforePrint; app.WorkbookBeforeSave += App_WorkbookBeforeSave; app.WorkbookBeforeXmlExport += App_WorkbookBeforeXmlExport; app.WorkbookBeforeXmlImport += App_WorkbookBeforeXmlImport; app.WorkbookDeactivate += App_WorkbookDeactivate; app.WorkbookModelChange += App_WorkbookModelChange; app.WorkbookNewChart += App_WorkbookNewChart; app.WorkbookNewSheet += App_WorkbookNewSheet; app.WorkbookOpen += App_WorkbookOpen; app.WorkbookPivotTableCloseConnection += App_WorkbookPivotTableCloseConnection; app.WorkbookPivotTableOpenConnection += App_WorkbookPivotTableOpenConnection; app.WorkbookRowsetComplete += App_WorkbookRowsetComplete; app.WorkbookSync += App_WorkbookSync; }
private void Button1_Click(object sender, EventArgs e) { label1.Text = ""; label1.Refresh(); if (xlsApp == null) { xlsApp = new Excel.Application(); xlsApp.Visible = true; excelCallBack = new ExcelCallBack(xlsApp); } else { xlsApp.Quit(); xlsApp = null; excelCallBack = null; } }