private XSSFDataValidation CreateValidation(XSSFSheet sheet) { //create the cell that will have the validation applied IRow row = sheet.CreateRow(0); row.CreateCell(0); IDataValidationHelper dataValidationHelper = sheet.GetDataValidationHelper(); IDataValidationConstraint constraint = dataValidationHelper.CreateCustomConstraint("true"); XSSFDataValidation validation = (XSSFDataValidation)dataValidationHelper.CreateValidation(constraint, new CellRangeAddressList(0, 0, 0, 0)); return(validation); }
public void TestDefaultAllowBlank() { XSSFWorkbook wb = new XSSFWorkbook(); try { XSSFSheet sheet = wb.CreateSheet() as XSSFSheet; XSSFDataValidation validation = CreateValidation(sheet); sheet.AddValidationData(validation); List <IDataValidation> dataValidations = sheet.GetDataValidations(); Assert.AreEqual(true, (dataValidations[0] as XSSFDataValidation).GetCTDataValidation().allowBlank); } finally { wb.Close(); } }
//YK: GetXYZArray() array accessors are deprecated in xmlbeans with JDK 1.5 support public List<XSSFDataValidation> GetDataValidations() { List<XSSFDataValidation> xssfValidations = new List<XSSFDataValidation>(); CT_DataValidations dataValidations = this.worksheet.dataValidations; if (dataValidations != null && dataValidations.count > 0) { foreach (CT_DataValidation ctDataValidation in dataValidations.dataValidation) { CellRangeAddressList addressList = new CellRangeAddressList(); List<String> sqref = ctDataValidation.sqref; foreach (String stRef in sqref) { String[] regions = stRef.Split(new char[] { ' ' }); for (int i = 0; i < regions.Length; i++) { String[] parts = regions[i].Split(new char[] { ':' }); CellReference begin = new CellReference(parts[0]); CellReference end = parts.Length > 1 ? new CellReference(parts[1]) : begin; CellRangeAddress cellRangeAddress = new CellRangeAddress(begin.Row, end.Row, begin.Col, end.Col); addressList.AddCellRangeAddress(cellRangeAddress); } } XSSFDataValidation xssfDataValidation = new XSSFDataValidation(addressList, ctDataValidation); xssfValidations.Add(xssfDataValidation); } } return xssfValidations; }