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:
createDateConstraint
in interfaceDataValidationHelper
-
createDecimalConstraint
public DataValidationConstraint createDecimalConstraint(int operatorType, String formula1, String formula2) - Specified by:
createDecimalConstraint
in interfaceDataValidationHelper
-
createExplicitListConstraint
- Specified by:
createExplicitListConstraint
in interfaceDataValidationHelper
-
createFormulaListConstraint
- Specified by:
createFormulaListConstraint
in interfaceDataValidationHelper
-
createNumericConstraint
public DataValidationConstraint createNumericConstraint(int validationType, int operatorType, String formula1, String formula2) - Specified by:
createNumericConstraint
in interfaceDataValidationHelper
-
createIntegerConstraint
public DataValidationConstraint createIntegerConstraint(int operatorType, String formula1, String formula2) - Specified by:
createIntegerConstraint
in interfaceDataValidationHelper
-
createTextLengthConstraint
public DataValidationConstraint createTextLengthConstraint(int operatorType, String formula1, String formula2) - Specified by:
createTextLengthConstraint
in interfaceDataValidationHelper
-
createTimeConstraint
public DataValidationConstraint createTimeConstraint(int operatorType, String formula1, String formula2) - Specified by:
createTimeConstraint
in interfaceDataValidationHelper
-
createCustomConstraint
- Specified by:
createCustomConstraint
in interfaceDataValidationHelper
-
createValidation
public DataValidation createValidation(DataValidationConstraint constraint, CellRangeAddressList cellRangeAddressList) - Specified by:
createValidation
in interfaceDataValidationHelper
-