| Package | Description |
|---|---|
| org.apache.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures 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 2018 The Apache Software Foundation or its licensors, as applicable.