去除Excel的Sheet中循环引用公式的方法

很简单，直接看代码即可：

 

ClearCircleReference
 1        /**//// <summary>
 2        /// Remove CircleReference 
 3        /// </summary>
 4        /// <param name="sheet">Worksheet object</param>
 5        private void ClearCircleReference(Worksheet sheet)
 6        {
 7            Range range = sheet.CircularReference;
 8            while (range != null)
 9            {
10                range.Clear();
11                range = sheet.CircularReference;
12            }
13        }

 

转载于:https://www.cnblogs.com/heblade/archive/2009/10/20/Excel_ClearCircleReference.html