Uses of Interface
org.apache.poi.ss.formula.functions.Function4Arg

Packages that use Function4Arg
org.apache.poi.ss.formula.functions   
 

Uses of Function4Arg in org.apache.poi.ss.formula.functions
 

Classes in org.apache.poi.ss.formula.functions that implement Function4Arg
 class FinanceFunction
           
 class Fixed4ArgFunction
          Convenience base class for functions that must take exactly four arguments.
 class Hlookup
          Implementation of the HLOOKUP() function.

HLOOKUP finds a column in a lookup table by the first row value and returns the value from another row.
Syntax:
HLOOKUP(lookup_value, table_array, row_index_num, range_lookup)

lookup_value The value to be found in the first column of the table array.
table_array An area reference for the lookup data.

 class Index
          Implementation for the Excel function INDEX
 class Replace
          An implementation of the Excel REPLACE() function:

Replaces part of a text string based on the number of characters you specify, with another text string.
Syntax:
REPLACE(oldText, startNum, numChars, newText)

oldText The text string containing characters to replace
startNum The position of the first character to replace (1-based)
numChars The number of characters to replace
newText The new text value to replace the removed section

 class Substitute
          An implementation of the SUBSTITUTE function:

Substitutes text in a text string with new text, some number of times.

 class Vlookup
          Implementation of the VLOOKUP() function.

VLOOKUP finds a row in a lookup table by the first column value and returns the value from another column.
Syntax:
VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

lookup_value The value to be found in the first column of the table array.
table_array An area reference for the lookup data.

 



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