Class Counta
- java.lang.Object
-
- org.apache.poi.ss.formula.functions.Counta
-
- All Implemented Interfaces:
Function
public final class Counta extends Object implements Function
Counts the number of cells that contain data within the list of arguments. Excel Syntax COUNTA(value1,value2,...) Value1, value2, ... are 1 to 30 arguments representing the values or ranges to be counted.
-
-
Constructor Summary
Constructors Constructor Description Counta()
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description ValueEval
evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
static Counta
subtotalInstance(boolean includeHiddenRows)
-
-
-
Method Detail
-
evaluate
public ValueEval evaluate(ValueEval[] args, int srcCellRow, int srcCellCol)
- Specified by:
evaluate
in interfaceFunction
- Parameters:
args
- the evaluated function arguments. Empty values are represented withBlankEval
orMissingArgEval
, nevernull
.srcCellRow
- row index of the cell containing the formula under evaluationsrcCellCol
- column index of the cell containing the formula under evaluation- Returns:
- The evaluated result, possibly an
ErrorEval
, nevernull
. Note - Excel uses the error code #NUM! instead of IEEE NaN, so when numeric functions evaluate toDouble.NaN
be sure to translate the result toErrorEval.NUM_ERROR
.
-
subtotalInstance
public static Counta subtotalInstance(boolean includeHiddenRows)
-
-