ASPOSE Excel java 单元格的下拉列表 验证

private void createStaticReport(Workbook workbook) {

WorksheetCollection worksheets = workbook.getWorksheets();
Worksheet worksheet = worksheets.get(0);


ValidationCollection validations = worksheet.getValidations();
int index = validations.add();
Validation validation = validations.get(index);
validation.setType(ValidationType.LIST);
validation.setOperator(OperatorType.BETWEEN);
validation.setIgnoreBlank(true);
validation.setInCellDropDown(true);
validation.setShowError(true);
validation.setShowInput(true);
validation.setInCellDropDown(true);
validation.setFormula1( "A,B,C,D,E");




validation.setShowError(true);
validation.setAlertStyle(ValidationAlertType.STOP);
validation.setErrorTitle("请选择地址");
validation.setErrorMessage("请从列表选择地址");
CellArea area = new CellArea();


area.StartRow = 0;
area.EndRow = 12;


area.StartColumn = 0;
area.EndColumn = 10;


validation.addArea(area);

}