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:
createDateConstraintin 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
-
createDecimalConstraint
public DataValidationConstraint createDecimalConstraint(int operatorType, String formula1, String formula2) - Specified by:
createDecimalConstraintin 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
-