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;
}
}
