spread winform 如何清除选中区域的数据?

spread winform 如何清除选中区域的数据?
因現在只可一個一個刪除..

回复 1楼rkk的帖子

参考代码如下：

1. 
   
2. Random r = new Random();
   
3. int i, j;
   
4. DialogResult dlg;
   
5. for (i = 0; i <= 3; i++)
   
6. {
   
7.     for (j = 0; j <= 3; j++)
   
8.     {
   
9.         fpSpread1.ActiveSheet.SetValue(i, j, r.Next() -100000);
   
10.     }
    
11. }
    
12. fpSpread1.ActiveSheet.SetFormula(5, 0, "Sum(A1, B2)");
    
13. fpSpread1.ActiveSheet.SetNote(5, 3, fpSpread1.ActiveSheet.Cells[2, 2].Text);
    
14. dlg = MessageBox.Show("Do you want to clear the range?", "ClearRange", MessageBoxButtons.YesNo);
    
15. if (dlg == DialogResult.Yes)
    
16. {
    
17.     fpSpread1.ActiveSheet.ClearRange(0, 0, 6, 6);
    
18. }
    
19. 
    

复制代码