| Package | Description |
|---|---|
| org.zkoss.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
| org.zkoss.poi.ss.usermodel | |
| org.zkoss.poi.xssf.usermodel |
| Modifier and Type | Class and Description |
|---|---|
class |
DVConstraint |
| Modifier and Type | Method and Description |
|---|---|
DataValidationConstraint |
HSSFDataValidationHelper.createAnyConstraint() |
DataValidationConstraint |
HSSFDataValidationHelper.createCustomConstraint(String formula) |
DataValidationConstraint |
HSSFDataValidationHelper.createDateConstraint(int operatorType,
String formula1,
String formula2,
String dateFormat) |
DataValidationConstraint |
HSSFDataValidationHelper.createDecimalConstraint(int operatorType,
String formula1,
String formula2) |
DataValidationConstraint |
HSSFDataValidationHelper.createExplicitListConstraint(String[] listOfValues) |
DataValidationConstraint |
HSSFDataValidationHelper.createFormulaListConstraint(String listFormula) |
DataValidationConstraint |
HSSFDataValidationHelper.createIntegerConstraint(int operatorType,
String formula1,
String formula2) |
DataValidationConstraint |
HSSFDataValidationHelper.createNumericConstraint(int validationType,
int operatorType,
String formula1,
String formula2) |
DataValidationConstraint |
HSSFDataValidationHelper.createTextLengthConstraint(int operatorType,
String formula1,
String formula2) |
DataValidationConstraint |
HSSFDataValidationHelper.createTimeConstraint(int operatorType,
String formula1,
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 |
|---|---|
DataValidation |
DataValidationHelper.createValidation(DataValidationConstraint constraint,
CellRangeAddressList cellRangeAddressList) |
| Modifier and Type | Class and Description |
|---|---|
class |
XSSFDataValidationConstraint |
| Modifier and Type | Method and Description |
|---|---|
DataValidationConstraint |
XSSFDataValidationHelper.createAnyConstraint() |
DataValidationConstraint |
XSSFDataValidationHelper.createCustomConstraint(String formula) |
DataValidationConstraint |
XSSFDataValidationHelper.createDateConstraint(int operatorType,
String formula1,
String formula2,
String dateFormat) |
DataValidationConstraint |
XSSFDataValidationHelper.createDecimalConstraint(int operatorType,
String formula1,
String formula2) |
DataValidationConstraint |
XSSFDataValidationHelper.createExplicitListConstraint(String[] listOfValues) |
DataValidationConstraint |
XSSFDataValidationHelper.createFormulaListConstraint(String listFormula) |
DataValidationConstraint |
XSSFDataValidationHelper.createIntegerConstraint(int operatorType,
String formula1,
String formula2) |
DataValidationConstraint |
XSSFDataValidationHelper.createNumericConstraint(int validationType,
int operatorType,
String formula1,
String formula2) |
DataValidationConstraint |
XSSFDataValidationHelper.createTextLengthConstraint(int operatorType,
String formula1,
String formula2) |
DataValidationConstraint |
XSSFDataValidationHelper.createTimeConstraint(int operatorType,
String formula1,
String formula2) |
DataValidationConstraint |
XSSFDataValidation.getValidationConstraint() |
| Modifier and Type | Method and Description |
|---|---|
DataValidation |
XSSFDataValidationHelper.createValidation(DataValidationConstraint constraint,
CellRangeAddressList cellRangeAddressList) |
Copyright © 2020. All rights reserved.