npio添加Data validation

XSSFDataValidationHelper dvHelper = new XSSFDataValidationHelper((XSSFSheet)sheet);
                    //设置数据源的值
                    XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint)dvHelper.CreateExplicitListConstraint(new List<string>() { "Y", "N" }.ToArray());
                    XSSFDataValidationConstraint dvRootCauseConstraint = (XSSFDataValidationConstraint)dvHelper.CreateExplicitListConstraint(new List<string>() { "12", "其他" }.ToArray());
                    //设置编辑的区域
                    CellRangeAddressList bLList = new CellRangeAddressList(1, oblModelList.Count() + 1, 17, 18);
                    CellRangeAddressList pIListS = new CellRangeAddressList(1, oblModelList.Count() + 1, 28, 28);
                    CellRangeAddressList pIListRootCause = new CellRangeAddressList(1, oblModelList.Count() + 1, 29, 29);
                    XSSFDataValidation validation = (XSSFDataValidation)dvHelper.CreateValidation(dvConstraint, bLList);
                    XSSFDataValidation validation1 = (XSSFDataValidation)dvHelper.CreateValidation(dvConstraint, pIListS);
                    XSSFDataValidation validationRootCause = (XSSFDataValidation)dvHelper.CreateValidation(dvRootCauseConstraint, pIListRootCause);
                    validation.SuppressDropDownArrow = true;
                    validation.ShowErrorBox = true;
                    validation1.SuppressDropDownArrow = true;
                    validation1.ShowErrorBox = true;
                    validationRootCause.SuppressDropDownArrow = true;
                    validationRootCause.ShowErrorBox = true;
                    sheet.AddValidationData(validation);
                    sheet.AddValidationData(validation1);
                    sheet.AddValidationData(validationRootCause);