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
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 |
XSSFDataValidationHelper
public XSSFDataValidationHelper(XSSFSheet xssfSheet)
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
Copyright 2012 The Apache Software Foundation or
its licensors, as applicable.