| Package | Description | 
|---|---|
| org.apache.poi.hssf.record | Record package contains class representations for XLS binary strutures. | 
| 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.ss.util | |
| org.apache.poi.xssf.usermodel | 
| Modifier and Type | Method and Description | 
|---|---|
| CellRangeAddressList | DVRecord. getCellRangeAddress() | 
| Constructor and Description | 
|---|
| DVRecord(int validationType,
        int operator,
        int errorStyle,
        boolean emptyCellAllowed,
        boolean suppressDropDownArrow,
        boolean isExplicitList,
        boolean showPromptBox,
        java.lang.String promptTitle,
        java.lang.String promptText,
        boolean showErrorBox,
        java.lang.String errorTitle,
        java.lang.String errorText,
        Ptg[] formula1,
        Ptg[] formula2,
        CellRangeAddressList regions) | 
| Modifier and Type | Method and Description | 
|---|---|
| CellRangeAddressList | HSSFDataValidation. getRegions() | 
| 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 | 
|---|---|
| CellRangeAddressList | DataValidation. getRegions() | 
| Modifier and Type | Method and Description | 
|---|---|
| DataValidation | DataValidationHelper. createValidation(DataValidationConstraint constraint,
                CellRangeAddressList cellRangeAddressList) | 
| Modifier and Type | Method and Description | 
|---|---|
| CellRangeAddressList | CellRangeAddressList. copy() | 
| Modifier and Type | Method and Description | 
|---|---|
| CellRangeAddressList | XSSFDataValidation. getRegions() | 
| Modifier and Type | Method and Description | 
|---|---|
| DataValidation | XSSFDataValidationHelper. createValidation(DataValidationConstraint constraint,
                CellRangeAddressList cellRangeAddressList) | 
| Constructor and Description | 
|---|
| XSSFDataValidation(XSSFDataValidationConstraint constraint,
                  CellRangeAddressList regions,
                  org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDataValidation ctDataValidation) | 
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.