org.apache.poi.xssf.usermodel

Class XSSFDataValidationHelper

java.lang.Object

org.apache.poi.xssf.usermodel.XSSFDataValidationHelper

All Implemented Interfaces:

DataValidationHelper

public class XSSFDataValidationHelper
extends java.lang.Object
implements DataValidationHelper

Author:

Radhakrishnan J

Constructor Summary

Constructors

Constructor and Description
XSSFDataValidationHelper(XSSFSheet xssfSheet)

Method Summary

Modifier and Type	Method and Description
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 (接口 DataValidationHelper 中的 createDateConstraint)

createDecimalConstraint

public DataValidationConstraint createDecimalConstraint(int operatorType,
                                                        java.lang.String formula1,
                                                        java.lang.String formula2)

Specified by:

createDecimalConstraint in interface DataValidationHelper (接口 DataValidationHelper 中的 createDecimalConstraint)

createExplicitListConstraint

public DataValidationConstraint createExplicitListConstraint(java.lang.String[] listOfValues)

Specified by:

createExplicitListConstraint in interface DataValidationHelper (接口 DataValidationHelper 中的 createExplicitListConstraint)

createFormulaListConstraint

public DataValidationConstraint createFormulaListConstraint(java.lang.String listFormula)

Specified by:

createFormulaListConstraint in interface DataValidationHelper (接口 DataValidationHelper 中的 createFormulaListConstraint)

createNumericConstraint

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

Specified by:

createNumericConstraint in interface DataValidationHelper (接口 DataValidationHelper 中的 createNumericConstraint)

createIntegerConstraint

public DataValidationConstraint createIntegerConstraint(int operatorType,
                                                        java.lang.String formula1,
                                                        java.lang.String formula2)

Specified by:

createIntegerConstraint in interface DataValidationHelper (接口 DataValidationHelper 中的 createIntegerConstraint)

createTextLengthConstraint

public DataValidationConstraint createTextLengthConstraint(int operatorType,
                                                           java.lang.String formula1,
                                                           java.lang.String formula2)

Specified by:

createTextLengthConstraint in interface DataValidationHelper (接口 DataValidationHelper 中的 createTextLengthConstraint)

createTimeConstraint

public DataValidationConstraint createTimeConstraint(int operatorType,
                                                     java.lang.String formula1,
                                                     java.lang.String formula2)

Specified by:

createTimeConstraint in interface DataValidationHelper (接口 DataValidationHelper 中的 createTimeConstraint)

createCustomConstraint

public DataValidationConstraint createCustomConstraint(java.lang.String formula)

Specified by:

createCustomConstraint in interface DataValidationHelper (接口 DataValidationHelper 中的 createCustomConstraint)

createValidation

public DataValidation createValidation(DataValidationConstraint constraint,
                                       CellRangeAddressList cellRangeAddressList)

Specified by:

createValidation in interface DataValidationHelper (接口 DataValidationHelper 中的 createValidation)