Package org.apache.poi.xssf.usermodel
Class XSSFDataValidationHelper
java.lang.Object
org.apache.poi.xssf.usermodel.XSSFDataValidationHelper
- All Implemented Interfaces:
DataValidationHelper
- Author:
- Radhakrishnan J
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptioncreateCustomConstraint(String formula) createDateConstraint(int operatorType, String formula1, String formula2, String dateFormat) createDecimalConstraint(int operatorType, String formula1, String formula2) createExplicitListConstraint(String[] listOfValues) createFormulaListConstraint(String listFormula) createIntegerConstraint(int operatorType, String formula1, String formula2) createNumericConstraint(int validationType, int operatorType, String formula1, String formula2) createTextLengthConstraint(int operatorType, String formula1, String formula2) createTimeConstraint(int operatorType, String formula1, String formula2) createValidation(DataValidationConstraint constraint, CellRangeAddressList cellRangeAddressList)
-
Constructor Details
-
XSSFDataValidationHelper
-
-
Method Details
-
createDateConstraint
public DataValidationConstraint createDateConstraint(int operatorType, String formula1, String formula2, String dateFormat) - Specified by:
createDateConstraintin interfaceDataValidationHelper
-
createDecimalConstraint
public DataValidationConstraint createDecimalConstraint(int operatorType, String formula1, String formula2) - Specified by:
createDecimalConstraintin interfaceDataValidationHelper
-
createExplicitListConstraint
- Specified by:
createExplicitListConstraintin interfaceDataValidationHelper
-
createFormulaListConstraint
- Specified by:
createFormulaListConstraintin interfaceDataValidationHelper
-
createNumericConstraint
public DataValidationConstraint createNumericConstraint(int validationType, int operatorType, String formula1, String formula2) - Specified by:
createNumericConstraintin interfaceDataValidationHelper
-
createIntegerConstraint
public DataValidationConstraint createIntegerConstraint(int operatorType, String formula1, String formula2) - Specified by:
createIntegerConstraintin interfaceDataValidationHelper
-
createTextLengthConstraint
public DataValidationConstraint createTextLengthConstraint(int operatorType, String formula1, String formula2) - Specified by:
createTextLengthConstraintin interfaceDataValidationHelper
-
createTimeConstraint
public DataValidationConstraint createTimeConstraint(int operatorType, String formula1, String formula2) - Specified by:
createTimeConstraintin interfaceDataValidationHelper
-
createCustomConstraint
- Specified by:
createCustomConstraintin interfaceDataValidationHelper
-
createValidation
public DataValidation createValidation(DataValidationConstraint constraint, CellRangeAddressList cellRangeAddressList) - Specified by:
createValidationin interfaceDataValidationHelper
-