public class XSSFDataValidationHelper extends java.lang.Object implements DataValidationHelper
Constructor and Description |
---|
XSSFDataValidationHelper(XSSFSheet xssfSheet) |
Modifier and Type | Method and Description |
---|---|
DataValidationConstraint |
createCustomConstraint(java.lang.String formula) |
DataValidationConstraint |
createDateConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2,
java.lang.String dateFormat) |
DataValidationConstraint |
createDecimalConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
createExplicitListConstraint(java.lang.String[] listOfValues) |
DataValidationConstraint |
createFormulaListConstraint(java.lang.String listFormula) |
DataValidationConstraint |
createIntegerConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
createNumericConstraint(int validationType,
int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
createTextLengthConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
createTimeConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidation |
createValidation(DataValidationConstraint constraint,
CellRangeAddressList cellRangeAddressList) |
public XSSFDataValidationHelper(XSSFSheet xssfSheet)
public DataValidationConstraint createDateConstraint(int operatorType, java.lang.String formula1, java.lang.String formula2, java.lang.String dateFormat)
createDateConstraint
in interface DataValidationHelper
public DataValidationConstraint createDecimalConstraint(int operatorType, java.lang.String formula1, java.lang.String formula2)
createDecimalConstraint
in interface DataValidationHelper
public DataValidationConstraint createExplicitListConstraint(java.lang.String[] listOfValues)
createExplicitListConstraint
in interface DataValidationHelper
public DataValidationConstraint createFormulaListConstraint(java.lang.String listFormula)
createFormulaListConstraint
in interface DataValidationHelper
public DataValidationConstraint createNumericConstraint(int validationType, int operatorType, java.lang.String formula1, java.lang.String formula2)
createNumericConstraint
in interface DataValidationHelper
public DataValidationConstraint createIntegerConstraint(int operatorType, java.lang.String formula1, java.lang.String formula2)
createIntegerConstraint
in interface DataValidationHelper
public DataValidationConstraint createTextLengthConstraint(int operatorType, java.lang.String formula1, java.lang.String formula2)
createTextLengthConstraint
in interface DataValidationHelper
public DataValidationConstraint createTimeConstraint(int operatorType, java.lang.String formula1, java.lang.String formula2)
createTimeConstraint
in interface DataValidationHelper
public DataValidationConstraint createCustomConstraint(java.lang.String formula)
createCustomConstraint
in interface DataValidationHelper
public DataValidation createValidation(DataValidationConstraint constraint, CellRangeAddressList cellRangeAddressList)
createValidation
in interface DataValidationHelper
Copyright 2022 The Apache Software Foundation or its licensors, as applicable.