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

java.lang.Object
  extended by org.apache.poi.hssf.record.formula.functions.TextFunction
      extended by org.apache.poi.hssf.record.formula.functions.Find
All Implemented Interfaces:
Function

public final class Find
extends TextFunction

Implementation of the FIND() function.

Syntax:
FIND(find_text, within_text, start_num)

FIND returns the character position of the first occurrence of find_text inside within_text. The third parameter, start_num, is optional (default=1) and specifies where to start searching from. Character positions are 1-based.

Author:
Torstein Tauno Svendsen (torstei@officenet.no)

Field Summary
 
Fields inherited from class org.apache.poi.hssf.record.formula.functions.TextFunction
CONCATENATE, EMPTY_STRING, EXACT, LEFT, LEN, LOWER, MID, RIGHT, TRIM, UPPER
 
Constructor Summary
Find()
           
 
Method Summary
protected  ValueEval evaluateFunc(ValueEval[] args, int srcCellRow, short srcCellCol)
           
 
Methods inherited from class org.apache.poi.hssf.record.formula.functions.TextFunction
evaluate, evaluateIntArg, evaluateStringArg
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

Find

public Find()
Method Detail

evaluateFunc

protected ValueEval evaluateFunc(ValueEval[] args,
                                 int srcCellRow,
                                 short srcCellCol)
                          throws EvaluationException
Specified by:
evaluateFunc in class TextFunction
Throws:
EvaluationException


Copyright 2009 The Apache Software Foundation or its licensors, as applicable.