npoi导出 带下拉选择框

XSSFDataValidationHelper helper = new XSSFDataValidationHelper((XSSFSheet)sheet);

CellRangeAddressList regions1 = new CellRangeAddressList(1, rowindex, 6, 6);
IDataValidation validation1 = helper.CreateValidation(helper.CreateExplicitListConstraint(new string[] { "正常", "旷考", "作弊", "取消" }), regions1);
sheet.AddValidationData(validation1);

CellRangeAddressList regions2 = new CellRangeAddressList(1, rowindex, 7, 7);
IDataValidation validation2 = helper.CreateValidation(helper.CreateExplicitListConstraint(new string[] { "正考", "缓考", "免修", "重修" }), regions2);
sheet.AddValidationData(validation2);