Package org.apache.poi.hssf.usermodel
Class HSSFDataValidationHelper
java.lang.Object
org.apache.poi.hssf.usermodel.HSSFDataValidationHelper
- All Implemented Interfaces:
DataValidationHelper
Helper for working with Data Validation
-
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
-
HSSFDataValidationHelper
-
-
Method Details
-
createDateConstraint
public DataValidationConstraint createDateConstraint(int operatorType, String formula1, String formula2, String dateFormat) - Specified by:
createDateConstraint
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
-
createDecimalConstraint
public DataValidationConstraint createDecimalConstraint(int operatorType, String formula1, String formula2) - Specified by:
createDecimalConstraint
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
-