Top Methods
org.apache.poi.ss.usermodel

public Interface DataValidationHelper

Known Direct Implementers
org.apache.poi.hssf.usermodel.HSSFDataValidationHelper
Imports
org.apache.poi.ss.util.CellRangeAddressList

Method Summary

Modifier and TypeMethod and Description
public DataValidationConstraint
createCustomConstraint(String formula)

public DataValidationConstraint
createDateConstraint(int operatorType, String formula1, String formula2, String dateFormat)

public DataValidationConstraint
createDecimalConstraint(int operatorType, String formula1, String formula2)

public DataValidationConstraint
createExplicitListConstraint(String[] listOfValues)

public DataValidationConstraint
createFormulaListConstraint(String listFormula)

public DataValidationConstraint
createIntegerConstraint(int operatorType, String formula1, String formula2)

public DataValidationConstraint
createNumericConstraint(int validationType, int operatorType, String formula1, String formula2)

public DataValidationConstraint
createTextLengthConstraint(int operatorType, String formula1, String formula2)

public DataValidationConstraint
createTimeConstraint(int operatorType, String formula1, String formula2)

public DataValidation
createValidation(DataValidationConstraint constraint, CellRangeAddressList cellRangeAddressList)

Method Detail

createCustomConstraintback to summary
public DataValidationConstraint createCustomConstraint(String formula)
createDateConstraintback to summary
public DataValidationConstraint createDateConstraint(int operatorType, String formula1, String formula2, String dateFormat)
createDecimalConstraintback to summary
public DataValidationConstraint createDecimalConstraint(int operatorType, String formula1, String formula2)
createExplicitListConstraintback to summary
public DataValidationConstraint createExplicitListConstraint(String[] listOfValues)
createFormulaListConstraintback to summary
public DataValidationConstraint createFormulaListConstraint(String listFormula)
createIntegerConstraintback to summary
public DataValidationConstraint createIntegerConstraint(int operatorType, String formula1, String formula2)
createNumericConstraintback to summary
public DataValidationConstraint createNumericConstraint(int validationType, int operatorType, String formula1, String formula2)
createTextLengthConstraintback to summary
public DataValidationConstraint createTextLengthConstraint(int operatorType, String formula1, String formula2)
createTimeConstraintback to summary
public DataValidationConstraint createTimeConstraint(int operatorType, String formula1, String formula2)
createValidationback to summary
public DataValidation createValidation(DataValidationConstraint constraint, CellRangeAddressList cellRangeAddressList)