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