日常开发中,导出基础数据为模版,填充信息后导入时,有时候会要求某些导入项应该为下拉框选择,一个是为了规范数据,也可以简化填充,下面上代码:
public static void setColumnToDropDownBoxFormat(XSSFSheet sheet, String[] dataList, int firstCol, int endCol) throws Exception {
XSSFDataValidationHelper dvHelper = new XSSFDataValidationHelper(sheet);
XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint) dvHelper
.createExplicitListConstraint(dataList);
CellRangeAddressList addressList = null;
XSSFDataValidation validation = null;
for (int i = 0; i < 500; i++) {
addressList = new CellRangeAddressList(i, i, firstCol, endCol);
validation = (XSSFDataValidation) dvHelper.createValidation(
dvConstraint, addressList);
sheet.addValidationData(validation);
}
}
导出前调用就可以了!