private void Application_SheetChange(object Sh, Excel.Range Target) { Excel.CustomProperty tableLoadedProperty = null; Excel.Worksheet activeSheet = ((Excel.Worksheet)Application.ActiveSheet); tableLoadedProperty = activeSheet.GetProperty("TableLoaded"); if (tableLoadedProperty != null) { activeSheet.AddChangedRow(Target); } }
private void excelEvents_SheetChange(object sender, object sheet, object range) { Excel.Worksheet changedSheet = null; Excel.Range changedRange = null; try { changedSheet = sheet as Excel.Worksheet; if (SheetChangeEvent && changedSheet.ConnectedToDb()) { changedRange = range as Excel.Range; changedSheet.AddChangedRow(changedRange); } } catch (Exception ex) { Console.Write(ex.Message); } finally { //if (changedSheet != null) Marshal.ReleaseComObject(changedSheet); // Disposed in DatabaseExplorerPane.tvTables_NodeMouseDoubleClick } }