public static CT_PatternFill Parse(XElement node, XmlNamespaceManager namespaceManager)
{
if (node == null)
{
return(null);
}
CT_PatternFill ctObj = new CT_PatternFill();
if (node.Attribute("patternType") != null)
{
ctObj.patternType = (ST_PatternType)Enum.Parse(typeof(ST_PatternType), node.Attribute("patternType").Value);
}
foreach (XElement childNode in node.ChildElements())
{
if (childNode.Name.LocalName == "fgColor")
{
ctObj.fgColor = CT_Color.Parse(childNode, namespaceManager);
}
else if (childNode.Name.LocalName == "bgColor")
{
ctObj.bgColor = CT_Color.Parse(childNode, namespaceManager);
}
}
return(ctObj);
}
public static CT_Colors Parse(XElement node, XmlNamespaceManager namespaceManager)
{
if (node == null)
{
return(null);
}
CT_Colors ctObj = new CT_Colors();
foreach (XElement childNode in node.ChildElements())
{
if (childNode.Name.LocalName == "indexedColors")
{
ctObj.indexedColors = new List <CT_RgbColor>();
foreach (XElement c2Node in childNode.ChildElements())
{
ctObj.indexedColors.Add(CT_RgbColor.Parse(c2Node, namespaceManager));
}
}
else if (childNode.Name.LocalName == "mruColors")
{
ctObj.mruColors = new List <CT_Color>();
foreach (XElement c2Node in childNode.ChildElements())
{
ctObj.mruColors.Add(CT_Color.Parse(c2Node, namespaceManager));
}
}
}
return(ctObj);
}
public static CT_SheetPr Parse(XElement node, XmlNamespaceManager namespaceManager)
{
if (node == null)
{
return(null);
}
CT_SheetPr ctObj = new CT_SheetPr();
ctObj.syncHorizontal = XmlHelper.ReadBool(node.Attribute("syncHorizontal"));
ctObj.syncVertical = XmlHelper.ReadBool(node.Attribute("syncVertical"));
ctObj.syncRef = XmlHelper.ReadString(node.Attribute("syncRef"));
ctObj.transitionEvaluation = XmlHelper.ReadBool(node.Attribute("transitionEvaluation"));
ctObj.transitionEntry = XmlHelper.ReadBool(node.Attribute("transitionEntry"));
ctObj.published = XmlHelper.ReadBool(node.Attribute("published"));
ctObj.codeName = XmlHelper.ReadString(node.Attribute("codeName"));
ctObj.filterMode = XmlHelper.ReadBool(node.Attribute("filterMode"));
ctObj.enableFormatConditionsCalculation = XmlHelper.ReadBool(node.Attribute("enableFormatConditionsCalculation"));
foreach (XElement childNode in node.ChildElements())
{
if (childNode.Name.LocalName == "tabColor")
{
ctObj.tabColor = CT_Color.Parse(childNode, namespaceManager);
}
else if (childNode.Name.LocalName == "outlinePr")
{
ctObj.outlinePr = CT_OutlinePr.Parse(childNode, namespaceManager);
}
else if (childNode.Name.LocalName == "pageSetUpPr")
{
ctObj.pageSetUpPr = CT_PageSetUpPr.Parse(childNode, namespaceManager);
}
}
return(ctObj);
}
public static CT_GradientStop Parse(XElement node, XmlNamespaceManager namespaceManager)
{
if (node == null)
{
return(null);
}
CT_GradientStop ctObj = new CT_GradientStop();
ctObj.positionField = XmlHelper.ReadInt(node.Attribute("position"));
foreach (XElement childNode in node.ChildElements())
{
if (childNode.Name.LocalName == "color")
{
ctObj.colorField = CT_Color.Parse(childNode, namespaceManager);
break;
}
}
return(ctObj);
}
public static CT_BorderPr Parse(XElement node, XmlNamespaceManager namespaceManager)
{
if (node == null)
{
return(null);
}
CT_BorderPr ctObj = new CT_BorderPr();
if (node.Attribute("style") != null)
{
ctObj.style = (ST_BorderStyle)Enum.Parse(typeof(ST_BorderStyle), node.Attribute("style").Value);
}
foreach (XElement childNode in node.ChildElements())
{
if (childNode.Name.LocalName == "color")
{
ctObj.color = CT_Color.Parse(childNode, namespaceManager);
}
}
return(ctObj);
}
public static CT_Font Parse(XElement node, XmlNamespaceManager namespaceManager)
{
if (node == null)
{
return(null);
}
CT_Font ctObj = new CT_Font();
ctObj.charset = new List <CT_IntProperty>();
ctObj.family = new List <CT_IntProperty>();
ctObj.b = new List <CT_BooleanProperty>();
ctObj.i = new List <CT_BooleanProperty>();
ctObj.strike = new List <CT_BooleanProperty>();
ctObj.color = new List <CT_Color>();
ctObj.sz = new List <CT_FontSize>();
ctObj.u = new List <CT_UnderlineProperty>();
ctObj.vertAlign = new List <CT_VerticalAlignFontProperty>();
ctObj.scheme = new List <CT_FontScheme>();
foreach (XElement childNode in node.ChildElements())
{
if (childNode.Name.LocalName == "outline")
{
ctObj.outline = CT_BooleanProperty.Parse(childNode, namespaceManager);
}
else if (childNode.Name.LocalName == "shadow")
{
ctObj.shadow = CT_BooleanProperty.Parse(childNode, namespaceManager);
}
else if (childNode.Name.LocalName == "condense")
{
ctObj.condense = CT_BooleanProperty.Parse(childNode, namespaceManager);
}
else if (childNode.Name.LocalName == "extend")
{
ctObj.extend = CT_BooleanProperty.Parse(childNode, namespaceManager);
}
else if (childNode.Name.LocalName == "name")
{
ctObj.name = CT_FontName.Parse(childNode, namespaceManager);
}
else if (childNode.Name.LocalName == "charset")
{
ctObj.charset.Add(CT_IntProperty.Parse(childNode, namespaceManager));
}
else if (childNode.Name.LocalName == "family")
{
ctObj.family.Add(CT_IntProperty.Parse(childNode, namespaceManager));
}
else if (childNode.Name.LocalName == "b")
{
ctObj.b.Add(CT_BooleanProperty.Parse(childNode, namespaceManager));
}
else if (childNode.Name.LocalName == "i")
{
ctObj.i.Add(CT_BooleanProperty.Parse(childNode, namespaceManager));
}
else if (childNode.Name.LocalName == "strike")
{
ctObj.strike.Add(CT_BooleanProperty.Parse(childNode, namespaceManager));
}
else if (childNode.Name.LocalName == "color")
{
ctObj.color.Add(CT_Color.Parse(childNode, namespaceManager));
}
else if (childNode.Name.LocalName == "sz")
{
ctObj.sz.Add(CT_FontSize.Parse(childNode, namespaceManager));
}
else if (childNode.Name.LocalName == "u")
{
ctObj.u.Add(CT_UnderlineProperty.Parse(childNode, namespaceManager));
}
else if (childNode.Name.LocalName == "vertAlign")
{
ctObj.vertAlign.Add(CT_VerticalAlignFontProperty.Parse(childNode, namespaceManager));
}
else if (childNode.Name.LocalName == "scheme")
{
ctObj.scheme.Add(CT_FontScheme.Parse(childNode, namespaceManager));
}
}
return(ctObj);
}
