org.zkoss.poi.xssf.usermodel

Class XSSFDataValidationHelper

java.lang.Object

org.zkoss.poi.xssf.usermodel.XSSFDataValidationHelper

All Implemented Interfaces:

DataValidationHelper

public class XSSFDataValidationHelper
extends Object
implements DataValidationHelper

Author:

Radhakrishnan J

Constructor Summary

Constructors

Constructor and Description
XSSFDataValidationHelper(XSSFSheet xssfSheet)

Method Summary

Modifier and Type	Method and Description
DataValidationConstraint	createAnyConstraint()
DataValidationConstraint	createCustomConstraint(String formula)
DataValidationConstraint	createDateConstraint(int operatorType, String formula1, String formula2, String dateFormat)
DataValidationConstraint	createDecimalConstraint(int operatorType, String formula1, String formula2)
DataValidationConstraint	createExplicitListConstraint(String[] listOfValues)
DataValidationConstraint	createFormulaListConstraint(String listFormula)
DataValidationConstraint	createIntegerConstraint(int operatorType, String formula1, String formula2)
DataValidationConstraint	createNumericConstraint(int validationType, int operatorType, String formula1, String formula2)
DataValidationConstraint	createTextLengthConstraint(int operatorType, String formula1, String formula2)
DataValidationConstraint	createTimeConstraint(int operatorType, String formula1, 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,
                                                     String formula1,
                                                     String formula2,
                                                     String dateFormat)

Specified by:

createDateConstraint in interface DataValidationHelper

createDecimalConstraint

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

Specified by:

createDecimalConstraint in interface DataValidationHelper

createExplicitListConstraint

public DataValidationConstraint createExplicitListConstraint(String[] listOfValues)

Specified by:

createExplicitListConstraint in interface DataValidationHelper

createFormulaListConstraint

public DataValidationConstraint createFormulaListConstraint(String listFormula)

Specified by:

createFormulaListConstraint in interface DataValidationHelper

createNumericConstraint

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

Specified by:

createNumericConstraint in interface DataValidationHelper

createIntegerConstraint

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

Specified by:

createIntegerConstraint in interface DataValidationHelper

createTextLengthConstraint

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

Specified by:

createTextLengthConstraint in interface DataValidationHelper

createTimeConstraint

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

Specified by:

createTimeConstraint in interface DataValidationHelper

createCustomConstraint

public DataValidationConstraint createCustomConstraint(String formula)

Specified by:

createCustomConstraint in interface DataValidationHelper

createValidation

public DataValidation createValidation(DataValidationConstraint constraint,
                                       CellRangeAddressList cellRangeAddressList)

Specified by:

createValidation in interface DataValidationHelper

createAnyConstraint

public DataValidationConstraint createAnyConstraint()

Specified by:

createAnyConstraint in interface DataValidationHelper