Class Index

  • All Implemented Interfaces:
    ArrayMode, Function, Function2Arg, Function3Arg, Function4Arg

    public final class Index
    extends java.lang.Object
    implements Function2Arg, Function3Arg, Function4Arg, ArrayMode
    Implementation for the Excel function INDEX

    Syntax :
    INDEX ( reference, row_num[, column_num [, area_num]])
    INDEX ( array, row_num[, column_num])

    referencetypically an area reference, possibly a union of areas
    arraya literal array value (currently not supported)
    row_numselects the row within the array or area reference
    column_numselects column within the array or area reference. default is 1
    area_numused when reference is a union of areas