public static SheetCellRange Formula2SheetRange(ICalcEvaluator evaluator, string formula) { CalcExternalRangeExpression expression = FormulaUtility.Formula2Expression(evaluator, formula) as CalcExternalRangeExpression; if (expression == null) { return(null); } return(new SheetCellRange(expression.Source as Worksheet, expression.StartRow, expression.StartColumn, (expression.EndRow - expression.StartRow) + 1, (expression.EndColumn - expression.StartColumn) + 1)); }
public static SheetCellRange[] ExtractAllExternalReference(ICalcEvaluator evaluator, string formula) { CalcExpression expression = FormulaUtility.Formula2Expression(evaluator, formula); if (expression == null) { return(null); } return(ExtractAllExternalReference(evaluator, expression)); }