|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
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. |
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |