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