public override Action <ISheet> SetExcelWorksheet()
{
return((s) =>
{
base.SetExcelWorksheet()(s);
var address = typeof(Student1).GetCellAddress(nameof(Student1.Email));
address = $"{address}2:{address}1000";
XSSFDataValidationHelper helper = new XSSFDataValidationHelper((XSSFSheet)s);
//创建验证规则
IDataValidationConstraint constraint = helper.CreateCustomConstraint($"=COUNTIF({address},\"?*@*.*\")");
var validation = helper.CreateValidation(constraint, new CellRangeAddressList(1, 1000, 0, 0));
//设置约束提示信息
validation.CreateErrorBox("错误", "请按右侧下拉箭头选择!");
validation.ShowErrorBox = true;
validation.ShowPromptBox = true;
validation.CreateErrorBox("请输入邮箱ErrorTitle", "请输入邮箱Error");
validation.CreatePromptBox("自定义错误信息PromptTitle", "自定义错误Prompt");
validation.ErrorStyle = 1;
s.AddValidationData(validation);
});
}
