org.apache.poi.hssf.record.formula.functions
Class Count

java.lang.Object
  org.apache.poi.hssf.record.formula.functions.Count

All Implemented Interfaces:

Function

public class Count
extends java.lang.Object
implements Function

Counts the number of cells that contain numeric data within the list of arguments. Excel Syntax COUNT(value1,value2,...) Value1, value2, ... are 1 to 30 arguments representing the values or ranges to be counted. TODO: Check this properly matches excel on edge cases like formula cells, error cells etc

Constructor Summary

Count()

Method Summary

Eval	evaluate(Eval[] args, int srcCellRow, short srcCellCol)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Count

public Count()

Method Detail

evaluate

public Eval evaluate(Eval[] args,
                     int srcCellRow,
                     short srcCellCol)

Specified by:

evaluate in interface Function