public override void FromXmlNode(XmlNode node)
{
this.ID = XmlHelper.GetAttributeText(node, "ID");
this.Name = XmlHelper.GetAttributeText(node, "Name");
XmlNode alignmentNode = node.SelectSingleNode("ss:Alignment", Namespaces.GetNamespaceManager());
if (alignmentNode != null)
{
Alignment.FromXmlNode(alignmentNode);
}
XmlNode bordersNode = node.SelectSingleNode("ss:Borders", Namespaces.GetNamespaceManager());
if (bordersNode != null)
{
Borders.FromXmlNode(bordersNode);
}
XmlNode fontNode = node.SelectSingleNode("ss:Font", Namespaces.GetNamespaceManager());
if (fontNode != null)
{
Font.FromXmlNode(fontNode);
}
XmlNode interiorNode = node.SelectSingleNode("ss:Interior", Namespaces.GetNamespaceManager());
if (interiorNode != null)
{
Interior.FromXmlNode(interiorNode);
}
XmlNode numberFormatNode = node.SelectSingleNode("ss:NumberFormat", Namespaces.GetNamespaceManager());
if (numberFormatNode != null)
{
NumberFormat.FromXmlNode(numberFormatNode);
}
XmlNode protectionNode = node.SelectSingleNode("ss:Protection", Namespaces.GetNamespaceManager());
if (protectionNode != null)
{
Protection.FromXmlNode(protectionNode);
}
}
public override void FromXmlNode(XmlNode node)
{
base.FromXmlNode(node);
this.Height = XmlHelper.GetAttributeValue(node, "Height", 0.0);
this.AutoFitHeight = XmlHelper.GetAttributeValue(node, "AutoFitHeight", true);
XmlNodeList cellNodes = node.SelectNodes("ss:Cell", Namespaces.GetNamespaceManager());
foreach (XmlNode cellNode in cellNodes)
{
CellNode cell = new CellNode();
cell.FromXmlNode(cellNode);
Cells.Add(cell);
}
}
public override void FromXmlNode(XmlNode node)
{
this.Index = XmlHelper.GetAttributeValue(node, "Index", 0);
this.StyleID = XmlHelper.GetAttributeText(node, "StyleID");
this.PasteFormula = XmlHelper.GetAttributeText(node, "PasteFormula", Namespaces.c);
this.ArrayRange = XmlHelper.GetAttributeText(node, "ArrayRange");
this.Formula = XmlHelper.GetAttributeText(node, "Formula");
this.HRef = XmlHelper.GetAttributeText(node, "HRef");
this.MergeAcross = XmlHelper.GetAttributeValue(node, "MergeAcross", 0);
this.MergeDown = XmlHelper.GetAttributeValue(node, "MergeDown", 0);
this.HRefScreenTip = XmlHelper.GetAttributeText(node, "HRefScreenTip", Namespaces.x);
XmlNode dataNode = node.SelectSingleNode("ss:Data", Namespaces.GetNamespaceManager());
if (dataNode != null)
{
Data.FromXmlNode(dataNode);
}
XmlNode commentNode = node.SelectSingleNode("ss:Comment", Namespaces.GetNamespaceManager());
if (commentNode != null)
{
Comment.FromXmlNode(commentNode);
}
XmlNode namedCellNode = node.SelectSingleNode("ss:NamedCell", Namespaces.GetNamespaceManager());
if (namedCellNode != null)
{
NamedCell.FromXmlNode(namedCellNode);
}
XmlNode phoneticTextNode = node.SelectSingleNode("ss:PhoneticText", Namespaces.GetNamespaceManager());
if (phoneticTextNode != null)
{
PhoneticText.FromXmlNode(phoneticTextNode);
}
}
public override void FromXmlNode(XmlNode node)
{
this.ExpandedColumnCount = XmlHelper.GetAttributeValue(node, "ExpandedColumnCount", 0);
this.ExpandedRowCount = XmlHelper.GetAttributeValue(node, "ExpandedRowCount", 0);
this.DefaultColumnWidth = XmlHelper.GetAttributeValue(node, "DefaultColumnWidth", 0.0);
this.DefaultRowHeight = XmlHelper.GetAttributeValue(node, "DefaultRowHeight", 0.0);
this.LeftCell = XmlHelper.GetAttributeValue(node, "LeftCell", 0);
this.TopCell = XmlHelper.GetAttributeValue(node, "TopCell", 0);
this.StyleID = XmlHelper.GetAttributeText(node, "StyleID");
this.FullColumns = XmlHelper.GetAttributeValue(node, "FullColumns", Namespaces.x, false);
this.FullRows = XmlHelper.GetAttributeValue(node, "FullRows", Namespaces.x, false);
XmlNodeList columnNodes = node.SelectNodes("ss:Column", Namespaces.GetNamespaceManager());
foreach (XmlNode columnNode in columnNodes)
{
ColumnNode column = new ColumnNode();
column.FromXmlNode(columnNode);
Columns.Add(column);
}
XmlNodeList rowNodes = node.SelectNodes("ss:Row", Namespaces.GetNamespaceManager());
foreach (XmlNode rowNode in rowNodes)
{
RowNode row = new RowNode();
row.FromXmlNode(rowNode);
Rows.Add(row);
}
}
public override void FromXmlNode(XmlNode node)
{
DocumentProperties.FromXmlNode(node.SelectSingleNode("o:DocumentProperties", Namespaces.GetNamespaceManager()));
ExcelWorkbook.FromXmlNode(node.SelectSingleNode("x:ExcelWorkbook", Namespaces.GetNamespaceManager()));
Styles.FromXmlNode(node.SelectSingleNode("ss:Styles", Namespaces.GetNamespaceManager()));
Worksheets.FromXmlNode(node);
XmlNode namesNodes = node.SelectSingleNode("ss:Names", Namespaces.GetNamespaceManager());
if (namesNodes != null)
{
Names.FromXmlNode(namesNodes);
}
}
public override void FromXmlNode(XmlNode node)
{
this.WindowHeight = XmlHelper.GetSingleNodeValue(node, "x:WindowHeight", Namespaces.GetNamespaceManager(), 8192);
this.WindowWidth = XmlHelper.GetSingleNodeValue(node, "x:WindowWidth", Namespaces.GetNamespaceManager(), 18000);
this.WindowTopX = XmlHelper.GetSingleNodeValue(node, "x:WindowTopX", Namespaces.GetNamespaceManager(), 480);
this.WindowTopY = XmlHelper.GetSingleNodeValue(node, "x:WindowTopY", Namespaces.GetNamespaceManager(), 75);
this.ProtectStructure = XmlHelper.GetSingleNodeValue(node, "x:ProtectStructure", Namespaces.GetNamespaceManager(), false);
this.ProtectWindows = XmlHelper.GetSingleNodeValue(node, "x:ProtectWindows", Namespaces.GetNamespaceManager(), false);
}
public override void FromXmlNode(XmlNode node)
{
this.Name = XmlHelper.GetAttributeText(node, "Name");
XmlNode worksheetOptionsNode = node.SelectSingleNode("x:WorksheetOptions", Namespaces.GetNamespaceManager());
if (worksheetOptionsNode != null)
{
WorksheetOptions.FromXmlNode(worksheetOptionsNode);
}
XmlNode tableNode = node.SelectSingleNode("ss:Table", Namespaces.GetNamespaceManager());
if (tableNode != null)
{
Table.FromXmlNode(tableNode);
}
XmlNode namesNode = node.SelectSingleNode("ss:Names", Namespaces.GetNamespaceManager());
if (namesNode != null)
{
Names.FromXmlNode(namesNode);
}
}
