Package | Description |
---|---|
org.zkoss.poi.ss.formula.functions |
Modifier and Type | Class and Description |
---|---|
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 © 2020. All rights reserved.