Examples of org.apache.poi.ss.formula.functions.Index

Package org.apache.poi.ss.formula.functions

Examples of org.apache.poi.ss.formula.functions.Index

org.apache.poi.ss.formula.functions.Index

Implementation for the Excel function INDEX

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

reference	typically an area reference, possibly a union of areas
array	a literal array value (currently not supported)
row_num	selects the row within the array or area reference
column_num	selects column within the array or area reference. default is 1
area_num	used when reference is a union of areas

@author Josh Micich

        retval[24] = NumericFunction.ABS;
        retval[25] = NumericFunction.INT;
        retval[26] = NumericFunction.SIGN;
        retval[27] = NumericFunction.ROUND;
        retval[28] = new Lookup();
        retval[29] = new Index();
        retval[30] = new Rept();


        retval[31] = TextFunction.MID;
        retval[32] = TextFunction.LEN;
        retval[33] = new Value();

View Full Code Here

        retval[24] = NumericFunction.ABS;
        retval[25] = NumericFunction.INT;
        retval[26] = NumericFunction.SIGN;
        retval[27] = NumericFunction.ROUND;
        retval[28] = new Lookup();
        retval[29] = new Index();
        retval[30] = new Rept();


        retval[31] = TextFunction.MID;
        retval[32] = TextFunction.LEN;
        retval[33] = new Value();

View Full Code Here

TOP

Related Classes of org.apache.poi.ss.formula.functions.Index

org.apache.poi.ss.formula.eval.FunctionEval

org.apache.poi.ss.formula.eval.ValueEval

org.apache.poi.ss.formula.TwoDEval

org.apache.poi.ss.formula.eval.EvaluationException

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.