需求描述:数据导出到Excel,新增对单元格的数据校验。
如图:
1、设置验证,首先要选择单元格的范围
CellRangeAddressList cellRegions = new CellRangeAddressList(1, 65535, 1, 1);
范围表示:选择第2行到第65535行,第二列
2、创建约束constraint
XSSFDataValidationHelper helper = new XSSFDataValidationHelper((XSSFSheet)sheet);
//创建约束
var dropDownConstraint = helper.CreateExplicitListConstraint(column.DropdownValidation);
//创建验证规则
IDataValidation dropDownValidation = helper.CreateValidation(dropDownConstraint, cellRegions); //column.DropdownValidation是一个数组new string[]{"男","女"}
//设置约束提示信息
dropDownValidation.CreateErrorBox("错误", "请按右侧下拉箭头选择!");
dropDownValidation.ShowErrorBox = true;
sheet.AddValidationData(d