GetRanges Method

GetRanges()

Declaration

public IEnumerable<IRange> GetRanges()

Public Function GetRanges() As IEnumerable(Of IRange)

Returns

Examples

CustomFunction function = new RefRangesFunction();
Workbook.AddCustomFunction(function, true);
worksheet.Range["A1:B2"].Value = new object[,] {{1, 2}, {3, 4}};
worksheet.Range["C1"].Formula = "=REFRANGES(A1:B2)";
object rangeCount = worksheet.Range["C1"].Value;

class RefRangesFunction : CustomFunction
{
    public RefRangesFunction()
        : base("REFRANGES", FunctionValueType.Number, new Parameter[] { new Parameter(FunctionValueType.Object, true, false) })
    {
    }

    public override object Evaluate(object[] arguments, ICalcContext context)
    {
        CalcReference reference = (CalcReference)arguments[0];
        List<IRange> ranges = new List<IRange>(reference.GetRanges());
        return (double)ranges.Count;
    }
}