很简单,直接看代码即可:
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 }
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 }