Top Description Constructors Methods
org.apache.poi.hssf.usermodel

public Class HSSFDataValidationHelper

extends Object
implements DataValidationHelper
Class Inheritance
All Implemented Interfaces
org.apache.poi.ss.usermodel.DataValidationHelper
Imports
org.apache.poi.ss.usermodel.DataValidation, .DataValidationConstraint, .DataValidationHelper, .DataValidationConstraint.ValidationType, org.apache.poi.ss.util.CellRangeAddressList
Helper for working with Data Validation

Constructor Summary

AccessConstructor and Description
public
HSSFDataValidationHelper(HSSFSheet sheet)

Method Summary

Modifier and TypeMethod and Description
public DataValidationConstraint
createCustomConstraint(String formula)

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createCustomConstraint.

public DataValidationConstraint
createDateConstraint(int operatorType, String formula1, String formula2, String dateFormat)

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createDateConstraint.

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

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createDecimalConstraint.

public DataValidationConstraint
createExplicitListConstraint(String[] listOfValues)

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createExplicitListConstraint.

public DataValidationConstraint
createFormulaListConstraint(String listFormula)

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createFormulaListConstraint.

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

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createIntegerConstraint.

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

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createNumericConstraint.

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

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createTextLengthConstraint.

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

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createTimeConstraint.

public DataValidation
createValidation(DataValidationConstraint constraint, CellRangeAddressList cellRangeAddressList)

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createValidation.

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait

Constructor Detail

HSSFDataValidationHelperback to summary
public HSSFDataValidationHelper(HSSFSheet sheet)

Method Detail

createCustomConstraintback to summary
public DataValidationConstraint createCustomConstraint(String formula)

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createCustomConstraint.

createDateConstraintback to summary
public DataValidationConstraint createDateConstraint(int operatorType, String formula1, String formula2, String dateFormat)

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createDateConstraint.

createDecimalConstraintback to summary
public DataValidationConstraint createDecimalConstraint(int operatorType, String formula1, String formula2)

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createDecimalConstraint.

createExplicitListConstraintback to summary
public DataValidationConstraint createExplicitListConstraint(String[] listOfValues)

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createExplicitListConstraint.

createFormulaListConstraintback to summary
public DataValidationConstraint createFormulaListConstraint(String listFormula)

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createFormulaListConstraint.

createIntegerConstraintback to summary
public DataValidationConstraint createIntegerConstraint(int operatorType, String formula1, String formula2)

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createIntegerConstraint.

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

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createNumericConstraint.

createTextLengthConstraintback to summary
public DataValidationConstraint createTextLengthConstraint(int operatorType, String formula1, String formula2)

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createTextLengthConstraint.

createTimeConstraintback to summary
public DataValidationConstraint createTimeConstraint(int operatorType, String formula1, String formula2)

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createTimeConstraint.

createValidationback to summary
public DataValidation createValidation(DataValidationConstraint constraint, CellRangeAddressList cellRangeAddressList)

Implements org.apache.poi.ss.usermodel.DataValidationHelper.createValidation.