public final class Hlookup
extends java.lang.Object
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.
row_index_num a 1 based index specifying which row value of the lookup data will be returned.
range_lookup If TRUE (default), HLOOKUP finds the largest value less than or equal to the lookup_value. If FALSE, only exact matches will be considered
Constructor and Description |
---|
Hlookup() |
Modifier and Type | Method and Description |
---|---|
ValueEval |
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
see
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
|
ValueEval |
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)
see
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
|
ValueEval |
evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex) |
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
Function3Arg
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)
Function4Arg
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
public final ValueEval evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
evaluate
in interface
Function
(在接口函数中求值)
args
- the evaluated function arguments. Empty values are represented with
BlankEval
or
MissingArgEval
, never
null
.
(args - 评估的函数参数。空值用 BlankEval 或 MissingArgEval 表示,绝不为 null。)
srcRowIndex
- row index of the cell containing the formula under evaluation
(srcRowIndex - 包含计算公式的单元格的行索引)
srcColumnIndex
- column index of the cell containing the formula under evaluation
(srcColumnIndex - 包含正在评估的公式的单元格的列索引)
ErrorEval
, never
null
.
Note - Excel uses the error code
#NUM! instead of IEEE
NaN, so when numeric functions evaluate to
Double.NaN
be sure to translate the result to
ErrorEval.NUM_ERROR
.
(评估结果,可能是 ErrorEval,绝不为空。注意 - Excel 使用错误代码 #NUM!而不是 IEEE NaN,因此当数值函数计算为 Double.NaN 时,请务必将结果转换为 ErrorEval.NUM_ERROR。)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.