vsto excel 区域添加列更改值对应区域变化

SheetChange事件频繁触发，Application.EnableEvents禁用，执行完在开启

 Application.EnableEvents = false;
   //method();
  Application.EnableEvents = true;

 

 

  public static void SyncRangeData(Excel.Range sourceRange, Excel.Range targetRange)
        {
            GC.Collect();
            try
            {
                if (sourceRange != null && targetRange != null)
                {
                    sourceRange.Copy(targetRange);
                }
            }
            catch (Exception ex)
            {
               
            }
        }