org.apache.poi.xssf.usermodel
Class XSSFDataValidationHelper

java.lang.Object
  extended by org.apache.poi.xssf.usermodel.XSSFDataValidationHelper
All Implemented Interfaces:
DataValidationHelper

public class XSSFDataValidationHelper
extends java.lang.Object
implements DataValidationHelper


Constructor Summary
XSSFDataValidationHelper(XSSFSheet xssfSheet)
           
 
Method Summary
 DataValidationConstraint createCustomConstraint(java.lang.String formula)
           
 DataValidationConstraint createDateConstraint(int operatorType, java.lang.String formula1, java.lang.String formula2, java.lang.String dateFormat)
           
 DataValidationConstraint createDecimalConstraint(int operatorType, java.lang.String formula1, java.lang.String formula2)
           
 DataValidationConstraint createExplicitListConstraint(java.lang.String[] listOfValues)
           
 DataValidationConstraint createFormulaListConstraint(java.lang.String listFormula)
           
 DataValidationConstraint createIntegerConstraint(int operatorType, java.lang.String formula1, java.lang.String formula2)
           
 DataValidationConstraint createNumericConstraint(int validationType, int operatorType, java.lang.String formula1, java.lang.String formula2)
           
 DataValidationConstraint createTextLengthConstraint(int operatorType, java.lang.String formula1, java.lang.String formula2)
           
 DataValidationConstraint createTimeConstraint(int operatorType, java.lang.String formula1, java.lang.String formula2)
           
 DataValidation createValidation(DataValidationConstraint constraint, CellRangeAddressList cellRangeAddressList)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

XSSFDataValidationHelper

public XSSFDataValidationHelper(XSSFSheet xssfSheet)
Method Detail

createDateConstraint

public DataValidationConstraint createDateConstraint(int operatorType,
                                                     java.lang.String formula1,
                                                     java.lang.String formula2,
                                                     java.lang.String dateFormat)
Specified by:
createDateConstraint in interface DataValidationHelper

createDecimalConstraint

public DataValidationConstraint createDecimalConstraint(int operatorType,
                                                        java.lang.String formula1,
                                                        java.lang.String formula2)
Specified by:
createDecimalConstraint in interface DataValidationHelper

createExplicitListConstraint

public DataValidationConstraint createExplicitListConstraint(java.lang.String[] listOfValues)
Specified by:
createExplicitListConstraint in interface DataValidationHelper

createFormulaListConstraint

public DataValidationConstraint createFormulaListConstraint(java.lang.String listFormula)
Specified by:
createFormulaListConstraint in interface DataValidationHelper

createNumericConstraint

public DataValidationConstraint createNumericConstraint(int validationType,
                                                        int operatorType,
                                                        java.lang.String formula1,
                                                        java.lang.String formula2)
Specified by:
createNumericConstraint in interface DataValidationHelper

createIntegerConstraint

public DataValidationConstraint createIntegerConstraint(int operatorType,
                                                        java.lang.String formula1,
                                                        java.lang.String formula2)
Specified by:
createIntegerConstraint in interface DataValidationHelper

createTextLengthConstraint

public DataValidationConstraint createTextLengthConstraint(int operatorType,
                                                           java.lang.String formula1,
                                                           java.lang.String formula2)
Specified by:
createTextLengthConstraint in interface DataValidationHelper

createTimeConstraint

public DataValidationConstraint createTimeConstraint(int operatorType,
                                                     java.lang.String formula1,
                                                     java.lang.String formula2)
Specified by:
createTimeConstraint in interface DataValidationHelper

createCustomConstraint

public DataValidationConstraint createCustomConstraint(java.lang.String formula)
Specified by:
createCustomConstraint in interface DataValidationHelper

createValidation

public DataValidation createValidation(DataValidationConstraint constraint,
                                       CellRangeAddressList cellRangeAddressList)
Specified by:
createValidation in interface DataValidationHelper