RangeCount Property

RangeCount

Declaration

public int RangeCount { get; }

Public ReadOnly Property RangeCount As Integer

Examples

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

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

    public override object Evaluate(object[] arguments, ICalcContext context)
    {
        CalcReference reference = (CalcReference)arguments[0];
        return (double)reference.RangeCount;
    }
}