Example usage for org.apache.poi.hssf.usermodel DVConstraint createDateConstraint

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel DVConstraint createDateConstraint.

Prototype

public static DVConstraint createDateConstraint(int comparisonOperator, String expr1, String expr2,
        String dateFormat) 

Source Link

Document

Creates a date based data validation constraint.

Usage

From source file:com.dituiba.excel.DefaultValidateAdapter.java

License:Apache License

/**
 * ?// w  ww  .  j a va 2s  .co  m
 * @param dataBean
 * @param sheet
 * @param columnIndex
 * @param filedName
 */
public void DateValidateAdapter(DataBean dataBean, Sheet sheet, int columnIndex, String filedName) {
    DateValidateConfig config = dataBean.getValidateConfig(filedName);
    DVConstraint dateConstraint = DVConstraint.createDateConstraint(
            DataValidationConstraint.OperatorType.BETWEEN, config.min(), config.max(), config.format());
    // ??,????
    CellRangeAddressList regions = new CellRangeAddressList(BaseExcelService.START_ROW, Short.MAX_VALUE,
            columnIndex, columnIndex);
    // ?
    DataValidation data_validation_list = new HSSFDataValidation(regions, dateConstraint);
    setValidationTip(data_validation_list, config);
    sheet.addValidationData(data_validation_list);
}

---