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);
}
