Package | Description |
---|---|
org.apache.poi.hssf.usermodel |
The usermodel package maps HSSF low level structures to familiar workbook/sheet model
|
org.apache.poi.ss.usermodel | |
org.apache.poi.xssf.usermodel |
Modifier and Type | Class and Description |
---|---|
class |
DVConstraint
Data Validation Constraint
|
Modifier and Type | Method and Description |
---|---|
DataValidationConstraint |
HSSFDataValidationHelper.createCustomConstraint(java.lang.String formula) |
DataValidationConstraint |
HSSFDataValidationHelper.createDateConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2,
java.lang.String dateFormat) |
DataValidationConstraint |
HSSFDataValidationHelper.createDecimalConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
HSSFDataValidationHelper.createExplicitListConstraint(java.lang.String[] listOfValues) |
DataValidationConstraint |
HSSFDataValidationHelper.createFormulaListConstraint(java.lang.String listFormula) |
DataValidationConstraint |
HSSFDataValidationHelper.createIntegerConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
HSSFDataValidationHelper.createNumericConstraint(int validationType,
int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
HSSFDataValidationHelper.createTextLengthConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
HSSFDataValidationHelper.createTimeConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
HSSFDataValidation.getValidationConstraint() |
Modifier and Type | Method and Description |
---|---|
DataValidation |
HSSFDataValidationHelper.createValidation(DataValidationConstraint constraint,
CellRangeAddressList cellRangeAddressList) |
Constructor and Description |
---|
HSSFDataValidation(CellRangeAddressList regions,
DataValidationConstraint constraint)
Constructor which initializes the cell range on which this object will be
applied
|
Modifier and Type | Method and Description |
---|---|
DataValidationConstraint |
DataValidationHelper.createCustomConstraint(java.lang.String formula) |
DataValidationConstraint |
DataValidationHelper.createDateConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2,
java.lang.String dateFormat) |
DataValidationConstraint |
DataValidationHelper.createDecimalConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
DataValidationHelper.createExplicitListConstraint(java.lang.String[] listOfValues) |
DataValidationConstraint |
DataValidationHelper.createFormulaListConstraint(java.lang.String listFormula) |
DataValidationConstraint |
DataValidationHelper.createIntegerConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
DataValidationHelper.createNumericConstraint(int validationType,
int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
DataValidationHelper.createTextLengthConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
DataValidationHelper.createTimeConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
DataValidation.getValidationConstraint() |
Modifier and Type | Method and Description |
---|---|
DataValidation |
DataValidationHelper.createValidation(DataValidationConstraint constraint,
CellRangeAddressList cellRangeAddressList) |
Modifier and Type | Class and Description |
---|---|
class |
XSSFDataValidationConstraint |
Modifier and Type | Method and Description |
---|---|
DataValidationConstraint |
XSSFDataValidationHelper.createCustomConstraint(java.lang.String formula) |
DataValidationConstraint |
XSSFDataValidationHelper.createDateConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2,
java.lang.String dateFormat) |
DataValidationConstraint |
XSSFDataValidationHelper.createDecimalConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
XSSFDataValidationHelper.createExplicitListConstraint(java.lang.String[] listOfValues) |
DataValidationConstraint |
XSSFDataValidationHelper.createFormulaListConstraint(java.lang.String listFormula) |
DataValidationConstraint |
XSSFDataValidationHelper.createIntegerConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
XSSFDataValidationHelper.createNumericConstraint(int validationType,
int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
XSSFDataValidationHelper.createTextLengthConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
XSSFDataValidationHelper.createTimeConstraint(int operatorType,
java.lang.String formula1,
java.lang.String formula2) |
DataValidationConstraint |
XSSFDataValidation.getValidationConstraint() |
Modifier and Type | Method and Description |
---|---|
DataValidation |
XSSFDataValidationHelper.createValidation(DataValidationConstraint constraint,
CellRangeAddressList cellRangeAddressList) |
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.