java - 需要一个 apache POI createDateConstraint 不使用公式的工作示例

Question

poi.apache.org网站给出了以下定义

公共(public)静态 DVConstraint createDateConstraint(int ComparisonOperator, java.lang.String expr1, java.lang.String expr2, java.lang.String dateFormat)

我想要一个示例，其中 expr1 和 expr2 是格式化日期值。

Answer 1

此代码适用于我将单元格样式设置为日期并在其上添加日期验证:

Cell cel= rowx.createCell(i);
cel.setCellStyle(style);
 XSSFCreationHelper createHelper = 
 workbook.getCreationHelper();
 short dateFormat = 
 createHelper.createDataFormat().getFormat("MM/dd/yyyy");
 style.setDataFormat(dateFormat);

 DataValidationHelper dvHelper = 
 sheet.getDataValidationHelper();
 DataValidationConstraint dvConstraint = 
      dvHelper.createDateConstraint(

 org.apache.poi.ss.usermodel. 
 DataValidationConstraint.OperatorType.BETWEEN, 
            "Date(1900, 1, 1)", 
            "Date(9999, 12, 31)", 
            "MM/dd/yyyy");
 CellRangeAddressList addressList = new CellRangeAddressList(
            2, pendingRowCount, columnNumber, columnNumber);
 DataValidation validation = 
 dvHelper.createValidation(dvConstraint, addressList);
 if (validation instanceof XSSFDataValidation) {
   validation.setSuppressDropDownArrow(true);
   validation.setShowErrorBox(true);
} else {
  validation.setSuppressDropDownArrow(false);
}
sheet.addValidationData(validation);