本文整理了Java中org.apache.poi.ss.formula.atp.YearFrac类的一些代码示例，展示了YearFrac类的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。YearFrac类的具体详情如下：
包路径：org.apache.poi.ss.formula.atp.YearFrac
类名称：YearFrac

YearFrac介绍

[英]Implementation of Excel 'Analysis ToolPak' function YEARFRAC()
Returns the fraction of the year spanned by two dates.

Syntax
YEARFRAC(startDate, endDate, basis)

The basis optionally specifies the behaviour of YEARFRAC as follows:
ValueDays per MonthDays per Year0 (default)303601actualactual2actual3603actual365430360
[中]Excel“分析工具包”功能YEARFRAC（）的实现
返回跨越两个日期的年份分数。
语法
YEARFRAC（开始日期、结束日期、基础）
依据选择性地规定了YEARFRAC的行为，如下所示：
ValueDays per MonthDays per Year0（默认值）303601实际天数2实际3603实际365430360

代码示例

代码示例来源：origin: org.apache.poi/poi

public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec) {
  int srcCellRow = ec.getRowIndex();
  int srcCellCol = ec.getColumnIndex();
  double result;
  try {
    int basis = 0; // default
    switch(args.length) {
      case 3:
        basis = evaluateIntArg(args[2], srcCellRow, srcCellCol);
        // fall through
      case 2:
        break;
      default:
        return ErrorEval.VALUE_INVALID;
    }
    double startDateVal = evaluateDateArg(args[0], srcCellRow, srcCellCol);
    double endDateVal = evaluateDateArg(args[1], srcCellRow, srcCellCol);
    result = YearFracCalculator.calculate(startDateVal, endDateVal, basis);
  } catch (EvaluationException e) {
    return e.getErrorEval();
  }
  return new NumberEval(result);
}

代码示例来源：origin: com.haulmont.thirdparty/poi

public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec) {
  int srcCellRow = ec.getRowIndex();
  int srcCellCol = ec.getColumnIndex();
  double result;
  try {
    int basis = 0; // default
    switch(args.length) {
      case 3:
        basis = evaluateIntArg(args[2], srcCellRow, srcCellCol);
      case 2:
        break;
      default:
        return ErrorEval.VALUE_INVALID;
    }
    double startDateVal = evaluateDateArg(args[0], srcCellRow, srcCellCol);
    double endDateVal = evaluateDateArg(args[1], srcCellRow, srcCellCol);
    result = YearFracCalculator.calculate(startDateVal, endDateVal, basis);
  } catch (EvaluationException e) {
    return e.getErrorEval();
  }
  return new NumberEval(result);
}

代码示例来源：origin: org.openl.rules/org.openl.lib.poi.dev

public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec) {
  int srcCellRow = ec.getRowIndex();
  int srcCellCol = ec.getColumnIndex();
  double result;
  try {
    int basis = 0; // default
    switch(args.length) {
      case 3:
        basis = evaluateIntArg(args[2], srcCellRow, srcCellCol);
      case 2:
        break;
      default:
        return ErrorEval.VALUE_INVALID;
    }
    double startDateVal = evaluateDateArg(args[0], srcCellRow, srcCellCol);
    double endDateVal = evaluateDateArg(args[1], srcCellRow, srcCellCol);
    result = YearFracCalculator.calculate(startDateVal, endDateVal, basis);
  } catch (EvaluationException e) {
    return e.getErrorEval();
  }
  return new NumberEval(result);
}

代码示例来源：origin: org.apache.servicemix.bundles/org.apache.servicemix.bundles.poi

public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec) {
  int srcCellRow = ec.getRowIndex();
  int srcCellCol = ec.getColumnIndex();
  double result;
  try {
    int basis = 0; // default
    switch(args.length) {
      case 3:
        basis = evaluateIntArg(args[2], srcCellRow, srcCellCol);
        // fall through
      case 2:
        break;
      default:
        return ErrorEval.VALUE_INVALID;
    }
    double startDateVal = evaluateDateArg(args[0], srcCellRow, srcCellCol);
    double endDateVal = evaluateDateArg(args[1], srcCellRow, srcCellCol);
    result = YearFracCalculator.calculate(startDateVal, endDateVal, basis);
  } catch (EvaluationException e) {
    return e.getErrorEval();
  }
  return new NumberEval(result);
}