XSSFWorkbook work = new XSSFWorkbook();
XSSFSheet sheet = work.createSheet("下拉框样式Sheet页");
String[] enumData = new String[] {"新增","修改","删除"};
XSSFDataValidationHelper dvHelper = new XSSFDataValidationHelper(sheet);
XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint) dvHelper
.createExplicitListConstraint(enumData);
CellRangeAddressList addressList = new CellRangeAddressList(1,100,0,0); //下拉选框作用范围,从第2行到第101行,从第1列到第1列
XSSFDataValidation validation = (XSSFDataValidation) dvHelper.createValidation(
dvConstraint, addressList);
validation.setShowErrorBox(true); //输入非法内容弹窗提示
sheet.addValidationData(validation);
POI设置单元格内容下拉框选择和单元格内容提示功能
最新推荐文章于 2024-05-23 11:23:35 发布