您好,
Spread里面有Selection可以实现选中相关操作
GetSelections是拿到选择的区域,AddSelection是添加一个选择区域。
- private void button1_Click(object sender, EventArgs e)
- {
- FarPoint.Win.Spread.Model.CellRange[] cr;
- cr = fpSpread1.ActiveSheet.GetSelections();
- int a = fpSpread1.ActiveSheet.ActiveCell.Row.Index;
- int b = fpSpread1.ActiveSheet.ActiveCell.Column.Index;
- this.fpSpread1.ActiveSheet.RemoveRows(0, 2);
- fpSpread1.ActiveSheet.SetActiveCell(a - 2, b);
- fpSpread1.ActiveSheet.AddSelection(0, 0, 2, 10);
- }
复制代码 |