private void ReadWorkSheet_dataValidations_Item_attribute(ExcelDataValidation item, XElement dataValidationNode) { XAttribute attribute = dataValidationNode.Attribute(XName.Get("allowBlank")); if (attribute != null) { item.AllowBlank = string.Compare(attribute.Value, "1") == 0 ? true : false; } attribute = dataValidationNode.Attribute(XName.Get("operator")); if (attribute != null) { if (!string.IsNullOrEmpty(attribute.Value)) { item.Operator = (ExcelDataValidationOperator)Enum.Parse(typeof(ExcelDataValidationOperator), attribute.Value); } } else { item.Operator = ExcelDataValidationOperator.between; } attribute = dataValidationNode.Attribute(XName.Get("showInputMessage")); if (attribute != null) { item.ShowInputMessage = string.Compare(attribute.Value, "1") == 0 ? true : false; } attribute = dataValidationNode.Attribute(XName.Get("showErrorMessage")); if (attribute != null) { item.ShowErrorMessage = string.Compare(attribute.Value, "1") == 0 ? true : false; } attribute = dataValidationNode.Attribute(XName.Get("errorTitle")); if (attribute != null) { item.ErrorTitle = attribute.Value; } attribute = dataValidationNode.Attribute(XName.Get("error")); if (attribute != null) { item.Error = attribute.Value; } attribute = dataValidationNode.Attribute(XName.Get("promptTitle")); if (attribute != null) { item.PromptTitle = attribute.Value; } attribute = dataValidationNode.Attribute(XName.Get("prompt")); if (attribute != null) { item.Prompt = attribute.Value; } }
private void ReadWorkSheet_dataValidations_Item(ExcelDataValidation item, XElement dataValidationNode) { ReadWorkSheet_dataValidations_Item_attribute(item, dataValidationNode); }