org.apache.poi.ss.usermodel
Interface DataValidationHelper
- All Known Implementing Classes:
- HSSFDataValidationHelper
public interface DataValidationHelper
Method Summary |
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)
|
createFormulaListConstraint
DataValidationConstraint createFormulaListConstraint(java.lang.String listFormula)
createExplicitListConstraint
DataValidationConstraint createExplicitListConstraint(java.lang.String[] listOfValues)
createNumericConstraint
DataValidationConstraint createNumericConstraint(int validationType,
int operatorType,
java.lang.String formula1,
java.lang.String formula2)
createTextLengthConstraint
DataValidationConstraint createTextLengthConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2)
createDecimalConstraint
DataValidationConstraint createDecimalConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2)
createIntegerConstraint
DataValidationConstraint createIntegerConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2)
createDateConstraint
DataValidationConstraint createDateConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2,
java.lang.String dateFormat)
createTimeConstraint
DataValidationConstraint createTimeConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2)
createCustomConstraint
DataValidationConstraint createCustomConstraint(java.lang.String formula)
createValidation
DataValidation createValidation(DataValidationConstraint constraint,
CellRangeAddressList cellRangeAddressList)