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

收藏

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

iceman · iceman

回复 1楼rkk的帖子

参考代码如下：

Random r = new Random();
int i, j;
DialogResult dlg;
for (i = 0; i <= 3; i++)
{
for (j = 0; j <= 3; j++)
{
fpSpread1.ActiveSheet.SetValue(i, j, r.Next() -100000);
}
}
fpSpread1.ActiveSheet.SetFormula(5, 0, "Sum(A1, B2)");
fpSpread1.ActiveSheet.SetNote(5, 3, fpSpread1.ActiveSheet.Cells[2, 2].Text);
dlg = MessageBox.Show("Do you want to clear the range?", "ClearRange", MessageBoxButtons.YesNo);
if (dlg == DialogResult.Yes)
{
fpSpread1.ActiveSheet.ClearRange(0, 0, 6, 6);
}

复制代码

		自动登录	找回密码
密码			立即注册

[已处理] spread winform 如何清除选中区域的数据?