public class WeekNum extends Fixed2ArgFunction implements FreeRefFunction
Syntax:
WeekNum (Serial_num,Return_type)
Returns a number that indicates where the week falls numerically within a year.
Serial_num is a date within the week. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text. Return_type is a number that determines on which day the week begins. The default is 1. 1 Week begins on Sunday. Weekdays are numbered 1 through 7. 2 Week begins on Monday. Weekdays are numbered 1 through 7.
(Excel WeekNum() 函数的实现。语法:WeekNum (Serial_num,Return_type) 返回一个数字,该数字指示一周在一年内的数字位置。 Serial_num 是一周内的日期。应使用 DATE 函数或其他公式或函数的结果输入日期。例如,将 DATE(2008,5,23) 用于 2008 年 5 月的第 23 天。如果将日期输入为文本,则可能会出现问题。 Return_type 是一个数字,用于确定一周从哪一天开始。默认值为 1。 1 周从星期日开始。工作日从 1 到 7 编号。 2 周从星期一开始。工作日编号为 1 到 7。)Modifier and Type | Field and Description |
---|---|
static FreeRefFunction |
instance |
Constructor and Description |
---|
WeekNum() |
Modifier and Type | Method and Description |
---|---|
ValueEval |
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval serialNumVE, ValueEval returnTypeVE)
see
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
|
ValueEval |
evaluate(ValueEval[] args, OperationEvaluationContext ec) |
int |
getWeekNo(java.util.Calendar cal, int weekStartOn) |
evaluate
public static final FreeRefFunction instance
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval serialNumVE, ValueEval returnTypeVE)
Function2Arg
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
evaluate
in interface
Function2Arg
(在接口 Function2Arg 中求值)
public int getWeekNo(java.util.Calendar cal, int weekStartOn)
public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec)
evaluate
in interface
FreeRefFunction
(在接口 FreeRefFunction 中求值)
args
- the pre-evaluated arguments for this function. args is never
null
, nor are any of its elements.
(args - 此函数的预评估参数。 args 永远不会为空,它的任何元素也不会。)
ec
- primarily used to identify the source cell containing the formula being evaluated. may also be used to dynamically create reference evals.
(ec - 主要用于识别包含正在评估的公式的源单元格。也可用于动态创建参考评估。)
null
. Possibly an instance of
ErrorEval in the case of a specified Excel error (Exceptions are never thrown to represent Excel errors).
(从不为空。在指定 Excel 错误的情况下可能是 ErrorEval 的一个实例(从不抛出异常来表示 Excel 错误)。)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.