添加列
fpSpread1.ActiveSheet.AddColumns(3,2)
通过公式获取区域
- FarPoint.Win.Spread.Model.DefaultSheetDataModel dm1;
- dm1 = fpSpread1.Sheets[0].Models.Data as FarPoint.Win.Spread.Model.DefaultSheetDataModel;
- FarPoint.CalcEngine.Expression ex1;
-
- ex1 = dm1.ParseFormula(0, 0, "A1:A2");
- FarPoint.CalcEngine.RangeExpression re1 = new FarPoint.CalcEngine.RangeExpression(0, 0, 1, 10, true, true);
- var rg = dm1.EvaluateExpression(0, 0, ex1);
复制代码 |