Overview  Package   Class  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

org.apache.poi.hssf.usermodel
Class HSSFDataValidationHelper

java.lang.Object
  extended by org.apache.poi.hssf.usermodel.HSSFDataValidationHelper
All Implemented Interfaces:
DataValidationHelper
public class HSSFDataValidationHelper
extends java.lang.Object
implements DataValidationHelper

Helper for working with Data Validation

Constructor Summary
HSSFDataValidationHelper(HSSFSheet sheet)
           
 
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

HSSFDataValidationHelper

public HSSFDataValidationHelper(HSSFSheet sheet)
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

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

createDecimalConstraint

public DataValidationConstraint createDecimalConstraint(int operatorType,
                                                        java.lang.String formula1,
                                                        java.lang.String formula2)
Specified by:
createDecimalConstraint 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
Overview  Package   Class  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD