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));
}