public static CT_SortState Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_SortState ctObj = new CT_SortState(); if (node.Attribute("columnSort") != null) { ctObj.columnSort = XmlHelper.ReadBool(node.Attribute("columnSort")); } if (node.Attribute("caseSensitive") != null) { ctObj.caseSensitive = XmlHelper.ReadBool(node.Attribute("caseSensitive")); } if (node.Attribute("sortMethod") != null) { ctObj.sortMethod = (ST_SortMethod)Enum.Parse(typeof(ST_SortMethod), node.Attribute("sortMethod").Value); } ctObj.@ref = XmlHelper.ReadString(node.Attribute("ref")); ctObj.sortCondition = new List <CT_SortCondition>(); foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "sortCondition") { ctObj.sortCondition.Add(CT_SortCondition.Parse(childNode, namespaceManager)); } } return(ctObj); }
public static CT_AutoFilter Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_AutoFilter ctObj = new CT_AutoFilter(); ctObj.@ref = XmlHelper.ReadString(node.Attribute("ref")); ctObj.filterColumn = new List <CT_FilterColumn>(); foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "sortState") { ctObj.sortState = CT_SortState.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "filterColumn") { ctObj.filterColumn.Add(CT_FilterColumn.Parse(childNode, namespaceManager)); } } return(ctObj); }
private CT_ExtensionList extLstField = null; // optional field public static CT_Comments Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Comments ctObj = new CT_Comments(); foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "authors") { ctObj.authors = CT_Authors.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "commentList") { ctObj.commentList = CT_CommentList.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } } return(ctObj); }
public static CT_XmlColumnPr Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_XmlColumnPr ctObj = new CT_XmlColumnPr(); if (node.Attribute("mapId") != null) { ctObj.mapId = XmlHelper.ReadUInt(node.Attribute("mapId")); } ctObj.xpath = XmlHelper.ReadString(node.Attribute("xpath")); if (node.Attribute("denormalized") != null) { ctObj.denormalized = XmlHelper.ReadBool(node.Attribute("denormalized")); } if (node.Attribute("xmlDataType") != null) { ctObj.xmlDataType = (ST_XmlDataType)Enum.Parse(typeof(ST_XmlDataType), node.Attribute("xmlDataType").Value); } foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } } return(ctObj); }
public static CT_BookView Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_BookView ctObj = new CT_BookView(); if (node.Attribute("visibility") != null) { ctObj.visibility = (ST_Visibility)Enum.Parse(typeof(ST_Visibility), node.Attribute("visibility").Value); } ctObj.minimized = XmlHelper.ReadBool(node.Attribute("minimized")); ctObj.showHorizontalScroll = XmlHelper.ReadBool(node.Attribute("showHorizontalScroll"), true); ctObj.showVerticalScroll = XmlHelper.ReadBool(node.Attribute("showVerticalScroll"), true); ctObj.showSheetTabs = XmlHelper.ReadBool(node.Attribute("showSheetTabs"), true); ctObj.xWindow = XmlHelper.ReadInt(node.Attribute("xWindow")); ctObj.yWindow = XmlHelper.ReadInt(node.Attribute("yWindow")); ctObj.windowWidth = XmlHelper.ReadUInt(node.Attribute("windowWidth")); ctObj.windowHeight = XmlHelper.ReadUInt(node.Attribute("windowHeight")); ctObj.tabRatio = XmlHelper.ReadUInt(node.Attribute("tabRatio")); ctObj.firstSheet = XmlHelper.ReadUInt(node.Attribute("firstSheet")); ctObj.activeTab = XmlHelper.ReadUInt(node.Attribute("activeTab")); ctObj.autoFilterDateGrouping = XmlHelper.ReadBool(node.Attribute("autoFilterDateGrouping"), true); foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } } return(ctObj); }
public static CT_TableColumn Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_TableColumn ctObj = new CT_TableColumn(); if (node.Attribute("id") != null) { ctObj.id = XmlHelper.ReadUInt(node.Attribute("id")); } ctObj.uniqueName = XmlHelper.ReadString(node.Attribute("uniqueName")); ctObj.name = XmlHelper.ReadString(node.Attribute("name")); if (node.Attribute("totalsRowFunction") != null) { ctObj.totalsRowFunction = (ST_TotalsRowFunction)Enum.Parse(typeof(ST_TotalsRowFunction), node.Attribute("totalsRowFunction").Value); } ctObj.totalsRowLabel = XmlHelper.ReadString(node.Attribute("totalsRowLabel")); if (node.Attribute("queryTableFieldId") != null) { ctObj.queryTableFieldId = XmlHelper.ReadUInt(node.Attribute("queryTableFieldId")); } if (node.Attribute("headerRowDxfId") != null) { ctObj.headerRowDxfId = XmlHelper.ReadUInt(node.Attribute("headerRowDxfId")); } if (node.Attribute("dataDxfId") != null) { ctObj.dataDxfId = XmlHelper.ReadUInt(node.Attribute("dataDxfId")); } if (node.Attribute("totalsRowDxfId") != null) { ctObj.totalsRowDxfId = XmlHelper.ReadUInt(node.Attribute("totalsRowDxfId")); } ctObj.headerRowCellStyle = XmlHelper.ReadString(node.Attribute("headerRowCellStyle")); ctObj.dataCellStyle = XmlHelper.ReadString(node.Attribute("dataCellStyle")); ctObj.totalsRowCellStyle = XmlHelper.ReadString(node.Attribute("totalsRowCellStyle")); foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "calculatedColumnFormula") { ctObj.calculatedColumnFormula = CT_TableFormula.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "totalsRowFormula") { ctObj.totalsRowFormula = CT_TableFormula.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "xmlColumnPr") { ctObj.xmlColumnPr = CT_XmlColumnPr.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } } return(ctObj); }
public static CT_Stylesheet Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Stylesheet ctObj = new CT_Stylesheet(); foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "numFmts") { ctObj.numFmts = CT_NumFmts.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "fonts") { ctObj.fonts = CT_Fonts.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "fills") { ctObj.fills = CT_Fills.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "borders") { ctObj.borders = CT_Borders.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "cellStyleXfs") { ctObj.cellStyleXfs = CT_CellStyleXfs.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "cellXfs") { ctObj.cellXfs = CT_CellXfs.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "cellStyles") { ctObj.cellStyles = CT_CellStyles.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "dxfs") { ctObj.dxfs = CT_Dxfs.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "tableStyles") { ctObj.tableStyles = CT_TableStyles.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "colors") { ctObj.colors = CT_Colors.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } } return(ctObj); }
public static CT_PivotCacheRecords Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_PivotCacheRecords ctObj = new CT_PivotCacheRecords(); if (node.Attribute("count") != null) { ctObj.count = XmlHelper.ReadUInt(node.Attribute("count")); } ctObj.r = new List <Object>(); foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "n") { ctObj.r.Add(CT_Number.Parse(childNode, namespaceManager)); } else if (childNode.Name.LocalName == "b") { ctObj.r.Add(CT_Boolean.Parse(childNode, namespaceManager)); } else if (childNode.Name.LocalName == "d") { ctObj.r.Add(CT_DateTime.Parse(childNode, namespaceManager)); } else if (childNode.Name.LocalName == "e") { ctObj.r.Add(CT_Error.Parse(childNode, namespaceManager)); } else if (childNode.Name.LocalName == "m") { ctObj.r.Add(CT_Missing.Parse(childNode, namespaceManager)); } else if (childNode.Name.LocalName == "s") { ctObj.r.Add(CT_String.Parse(childNode, namespaceManager)); } else if (childNode.Name.LocalName == "x") { ctObj.r.Add(CT_Index.Parse(childNode, namespaceManager)); } } return(ctObj); }
public static CT_CustomWorkbookView Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_CustomWorkbookView ctObj = new CT_CustomWorkbookView(); ctObj.name = XmlHelper.ReadString(node.Attribute("name")); ctObj.guid = XmlHelper.ReadString(node.Attribute("guid")); ctObj.autoUpdate = XmlHelper.ReadBool(node.Attribute("autoUpdate")); ctObj.mergeInterval = XmlHelper.ReadUInt(node.Attribute("mergeInterval")); ctObj.mergeIntervalSpecified = node.Attribute("mergeInterval") != null; ctObj.changesSavedWin = XmlHelper.ReadBool(node.Attribute("changesSavedWin")); ctObj.onlySync = XmlHelper.ReadBool(node.Attribute("onlySync")); ctObj.personalView = XmlHelper.ReadBool(node.Attribute("personalView")); ctObj.includePrintSettings = XmlHelper.ReadBool(node.Attribute("includePrintSettings")); ctObj.includeHiddenRowCol = XmlHelper.ReadBool(node.Attribute("includeHiddenRowCol")); ctObj.maximized = XmlHelper.ReadBool(node.Attribute("maximized")); ctObj.minimized = XmlHelper.ReadBool(node.Attribute("minimized")); ctObj.showHorizontalScroll = XmlHelper.ReadBool(node.Attribute("showHorizontalScroll")); ctObj.showVerticalScroll = XmlHelper.ReadBool(node.Attribute("showVerticalScroll")); ctObj.showSheetTabs = XmlHelper.ReadBool(node.Attribute("showSheetTabs")); ctObj.xWindow = XmlHelper.ReadInt(node.Attribute("xWindow")); ctObj.yWindow = XmlHelper.ReadInt(node.Attribute("yWindow")); ctObj.windowWidth = XmlHelper.ReadUInt(node.Attribute("windowWidth")); ctObj.windowHeight = XmlHelper.ReadUInt(node.Attribute("windowHeight")); ctObj.tabRatio = XmlHelper.ReadUInt(node.Attribute("tabRatio")); ctObj.activeSheetId = XmlHelper.ReadUInt(node.Attribute("activeSheetId")); ctObj.showFormulaBar = XmlHelper.ReadBool(node.Attribute("showFormulaBar")); ctObj.showStatusbar = XmlHelper.ReadBool(node.Attribute("showStatusbar")); if (node.Attribute("showComments") != null) { ctObj.showComments = (ST_Comments)Enum.Parse(typeof(ST_Comments), node.Attribute("showComments").Value); } if (node.Attribute("showObjects") != null) { ctObj.showObjects = (ST_Objects)Enum.Parse(typeof(ST_Objects), node.Attribute("showObjects").Value); } foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } } return(ctObj); }
public static CT_Dxf Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Dxf ctObj = new CT_Dxf(); foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "font") { ctObj.font = CT_Font.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "numFmt") { ctObj.numFmt = CT_NumFmt.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "fill") { ctObj.fill = CT_Fill.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "alignment") { ctObj.alignment = CT_CellAlignment.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "border") { ctObj.border = CT_Border.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "protection") { ctObj.protection = CT_CellProtection.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } } return(ctObj); }
public static CT_Cell Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Cell ctObj = new CT_Cell(); ctObj.r = XmlHelper.ReadString(node.Attribute("r")); ctObj.s = XmlHelper.ReadUInt(node.Attribute("s")); if (node.Attribute("t") != null) { ctObj.t = (ST_CellType)Enum.Parse(typeof(ST_CellType), node.Attribute("t").Value); } ctObj.cm = XmlHelper.ReadUInt(node.Attribute("cm")); ctObj.vm = XmlHelper.ReadUInt(node.Attribute("vm")); ctObj.ph = XmlHelper.ReadBool(node.Attribute("ph")); foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "f") { ctObj.f = CT_CellFormula.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "v") { ctObj.v = childNode.Value; } else if (childNode.Name.LocalName == "is") { ctObj.@is = CT_Rst.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } } return(ctObj); }
public static CT_Xf Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Xf ctObj = new CT_Xf(); ctObj.numFmtId = XmlHelper.ReadUInt(node.Attribute("numFmtId")); ctObj.fontId = XmlHelper.ReadUInt(node.Attribute("fontId")); ctObj.fillId = XmlHelper.ReadUInt(node.Attribute("fillId")); ctObj.borderId = XmlHelper.ReadUInt(node.Attribute("borderId")); ctObj.xfId = XmlHelper.ReadUInt(node.Attribute("xfId")); ctObj.quotePrefix = XmlHelper.ReadBool(node.Attribute("quotePrefix")); ctObj.pivotButton = XmlHelper.ReadBool(node.Attribute("pivotButton")); ctObj.applyNumberFormat = XmlHelper.ReadBool(node.Attribute("applyNumberFormat")); ctObj.applyFont = XmlHelper.ReadBool(node.Attribute("applyFont")); ctObj.applyFill = XmlHelper.ReadBool(node.Attribute("applyFill")); ctObj.applyBorder = XmlHelper.ReadBool(node.Attribute("applyBorder")); ctObj.applyAlignment = XmlHelper.ReadBool(node.Attribute("applyAlignment")); ctObj.applyProtection = XmlHelper.ReadBool(node.Attribute("applyProtection")); foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "alignment") { ctObj.alignment = CT_CellAlignment.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "protection") { ctObj.protection = CT_CellProtection.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } } return(ctObj); }
public static CT_CellStyle Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_CellStyle ctObj = new CT_CellStyle(); ctObj.name = XmlHelper.ReadString(node.Attribute("name")); ctObj.xfId = XmlHelper.ReadUInt(node.Attribute("xfId")); ctObj.builtinId = XmlHelper.ReadUInt(node.Attribute("builtinId")); ctObj.iLevel = XmlHelper.ReadUInt(node.Attribute("iLevel")); ctObj.hidden = XmlHelper.ReadBool(node.Attribute("hidden")); ctObj.customBuiltin = XmlHelper.ReadBool(node.Attribute("customBuiltin")); foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } } return(ctObj); }
public static CT_Row Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Row ctObj = new CT_Row(); ctObj.r = XmlHelper.ReadUInt(node.Attribute("r")); ctObj.spans = XmlHelper.ReadString(node.Attribute("spans")); ctObj.s = XmlHelper.ReadUInt(node.Attribute("s")); ctObj.customFormat = XmlHelper.ReadBool(node.Attribute("customFormat")); if (node.Attribute("ht") != null) { ctObj.ht = XmlHelper.ReadDouble(node.Attribute("ht")); } ctObj.hidden = XmlHelper.ReadBool(node.Attribute("hidden")); ctObj.outlineLevel = XmlHelper.ReadByte(node.Attribute("outlineLevel")); ctObj.customHeight = XmlHelper.ReadBool(node.Attribute("customHeight")); ctObj.collapsed = XmlHelper.ReadBool(node.Attribute("collapsed")); ctObj.thickTop = XmlHelper.ReadBool(node.Attribute("thickTop")); ctObj.thickBot = XmlHelper.ReadBool(node.Attribute("thickBot")); ctObj.ph = XmlHelper.ReadBool(node.Attribute("ph")); ctObj.c = new List <CT_Cell>(); foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "c") { ctObj.c.Add(CT_Cell.Parse(childNode, namespaceManager)); } } return(ctObj); }
public static CT_ExternalLink Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_ExternalLink ctObj = new CT_ExternalLink(); foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "externalBook") { ctObj.externalBookField = CT_ExternalBook.Parse(childNode, namespaceManager); ctObj.itemField = ctObj.externalBookField; ctObj.itemType = ExternalLinkItem.externalBook; } else if (childNode.Name.LocalName == "ddeLink") { ctObj.ddeLinkField = CT_DdeLink.Parse(childNode, namespaceManager); ctObj.itemField = ctObj.ddeLinkField; ctObj.itemType = ExternalLinkItem.ddeLink; } else if (childNode.Name.LocalName == "oleLink") { ctObj.oleLinkField = CT_OleLink.Parse(childNode, namespaceManager); ctObj.itemField = ctObj.oleLinkField; ctObj.itemType = ExternalLinkItem.oleLink; } else if (childNode.Name.LocalName == "extLst") { ctObj.extLstField = CT_ExtensionList.Parse(childNode, namespaceManager); ctObj.itemField = ctObj.extLstField; ctObj.itemType = ExternalLinkItem.extLst; } } return(ctObj); }
public static CT_Worksheet Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Worksheet ctObj = new CT_Worksheet(); ctObj.cols = new List <CT_Cols>(); ctObj.conditionalFormatting = new List <CT_ConditionalFormatting>(); foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "sheetPr") { ctObj.sheetPr = CT_SheetPr.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "dimension") { ctObj.dimension = CT_SheetDimension.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "sheetViews") { ctObj.sheetViews = CT_SheetViews.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "sheetFormatPr") { ctObj.sheetFormatPr = CT_SheetFormatPr.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "sheetData") { ctObj.sheetData = CT_SheetData.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "sheetCalcPr") { ctObj.sheetCalcPr = CT_SheetCalcPr.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "sheetProtection") { ctObj.sheetProtection = CT_SheetProtection.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "protectedRanges") { ctObj.protectedRanges = CT_ProtectedRanges.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "scenarios") { ctObj.scenarios = CT_Scenarios.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "autoFilter") { ctObj.autoFilter = CT_AutoFilter.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "sortState") { ctObj.sortState = CT_SortState.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "dataConsolidate") { ctObj.dataConsolidate = CT_DataConsolidate.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "customSheetViews") { ctObj.customSheetViews = CT_CustomSheetViews.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "mergeCells") { ctObj.mergeCells = CT_MergeCells.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "phoneticPr") { ctObj.phoneticPr = CT_PhoneticPr.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "dataValidations") { ctObj.dataValidations = CT_DataValidations.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "hyperlinks") { ctObj.hyperlinks = CT_Hyperlinks.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "printOptions") { ctObj.printOptions = CT_PrintOptions.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "pageMargins") { ctObj.pageMargins = CT_PageMargins.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "pageSetup") { ctObj.pageSetup = CT_PageSetup.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "headerFooter") { ctObj.headerFooter = CT_HeaderFooter.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "rowBreaks") { ctObj.rowBreaks = CT_PageBreak.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "colBreaks") { ctObj.colBreaks = CT_PageBreak.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "customProperties") { ctObj.customProperties = CT_CustomProperties.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "cellWatches") { ctObj.cellWatches = CT_CellWatches.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "ignoredErrors") { ctObj.ignoredErrors = CT_IgnoredErrors.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "smartTags") { ctObj.smartTags = CT_CellSmartTags.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "drawing") { ctObj.drawing = CT_Drawing.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "legacyDrawing") { ctObj.legacyDrawing = CT_LegacyDrawing.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "legacyDrawingHF") { ctObj.legacyDrawingHF = CT_LegacyDrawing.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "picture") { ctObj.picture = CT_SheetBackgroundPicture.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "oleObjects") { ctObj.oleObjects = CT_OleObjects.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "controls") { ctObj.controls = CT_Controls.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "webPublishItems") { ctObj.webPublishItems = CT_WebPublishItems.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "tableParts") { ctObj.tableParts = CT_TableParts.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "cols") { ctObj.cols.Add(CT_Cols.Parse(childNode, namespaceManager)); } else if (childNode.Name.LocalName == "conditionalFormatting") { ctObj.conditionalFormatting.Add(CT_ConditionalFormatting.Parse(childNode, namespaceManager)); } } return(ctObj); }
public static CT_Table Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Table ctObj = new CT_Table(); if (node.Attribute("id") != null) { ctObj.id = XmlHelper.ReadUInt(node.Attribute("id")); } ctObj.name = XmlHelper.ReadString(node.Attribute("name")); ctObj.displayName = XmlHelper.ReadString(node.Attribute("displayName")); ctObj.comment = XmlHelper.ReadString(node.Attribute("comment")); ctObj.@ref = XmlHelper.ReadString(node.Attribute("ref")); if (node.Attribute("tableType") != null) { ctObj.tableType = (ST_TableType)Enum.Parse(typeof(ST_TableType), node.Attribute("tableType").Value); } if (node.Attribute("headerRowCount") != null) { ctObj.headerRowCount = XmlHelper.ReadUInt(node.Attribute("headerRowCount")); } if (node.Attribute("insertRow") != null) { ctObj.insertRow = XmlHelper.ReadBool(node.Attribute("insertRow")); } if (node.Attribute("insertRowShift") != null) { ctObj.insertRowShift = XmlHelper.ReadBool(node.Attribute("insertRowShift")); } if (node.Attribute("totalsRowCount") != null) { ctObj.totalsRowCount = XmlHelper.ReadUInt(node.Attribute("totalsRowCount")); } if (node.Attribute("totalsRowShown") != null) { ctObj.totalsRowShown = XmlHelper.ReadBool(node.Attribute("totalsRowShown")); } if (node.Attribute("published") != null) { ctObj.published = XmlHelper.ReadBool(node.Attribute("published")); } if (node.Attribute("headerRowDxfId") != null) { ctObj.headerRowDxfId = XmlHelper.ReadUInt(node.Attribute("headerRowDxfId")); } if (node.Attribute("dataDxfId") != null) { ctObj.dataDxfId = XmlHelper.ReadUInt(node.Attribute("dataDxfId")); } if (node.Attribute("totalsRowDxfId") != null) { ctObj.totalsRowDxfId = XmlHelper.ReadUInt(node.Attribute("totalsRowDxfId")); } if (node.Attribute("headerRowBorderDxfId") != null) { ctObj.headerRowBorderDxfId = XmlHelper.ReadUInt(node.Attribute("headerRowBorderDxfId")); } if (node.Attribute("tableBorderDxfId") != null) { ctObj.tableBorderDxfId = XmlHelper.ReadUInt(node.Attribute("tableBorderDxfId")); } if (node.Attribute("totalsRowBorderDxfId") != null) { ctObj.totalsRowBorderDxfId = XmlHelper.ReadUInt(node.Attribute("totalsRowBorderDxfId")); } ctObj.headerRowCellStyle = XmlHelper.ReadString(node.Attribute("headerRowCellStyle")); ctObj.dataCellStyle = XmlHelper.ReadString(node.Attribute("dataCellStyle")); ctObj.totalsRowCellStyle = XmlHelper.ReadString(node.Attribute("totalsRowCellStyle")); if (node.Attribute("connectionId") != null) { ctObj.connectionId = XmlHelper.ReadUInt(node.Attribute("connectionId")); } foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "autoFilter") { ctObj.autoFilter = CT_AutoFilter.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "sortState") { ctObj.sortState = CT_SortState.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "tableColumns") { ctObj.tableColumns = CT_TableColumns.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "tableStyleInfo") { ctObj.tableStyleInfo = CT_TableStyleInfo.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } } return(ctObj); }
public static CT_Workbook Parse(XElement node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Workbook ctObj = new CT_Workbook(); ctObj.fileRecoveryPr = new List <CT_FileRecoveryPr>(); foreach (XElement childNode in node.ChildElements()) { if (childNode.Name.LocalName == "fileVersion") { ctObj.fileVersion = CT_FileVersion.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "fileSharing") { ctObj.fileSharing = CT_FileSharing.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "workbookPr") { ctObj.workbookPr = CT_WorkbookPr.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "workbookProtection") { ctObj.workbookProtection = CT_WorkbookProtection.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "bookViews") { ctObj.bookViews = CT_BookViews.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "sheets") { ctObj.sheets = CT_Sheets.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "functionGroups") { ctObj.functionGroups = CT_FunctionGroups.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "externalReferences") { ctObj.externalReferences = CT_ExternalReferences.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "definedNames") { ctObj.definedNames = CT_DefinedNames.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "calcPr") { ctObj.calcPr = CT_CalcPr.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "oleSize") { ctObj.oleSize = CT_OleSize.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "customWorkbookViews") { ctObj.customWorkbookViews = CT_CustomWorkbookViews.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "pivotCaches") { ctObj.pivotCaches = CT_PivotCaches.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "smartTagPr") { ctObj.smartTagPr = CT_SmartTagPr.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "smartTagTypes") { ctObj.smartTagTypes = CT_SmartTagTypes.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "webPublishing") { ctObj.webPublishing = CT_WebPublishing.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "webPublishObjects") { ctObj.webPublishObjects = CT_WebPublishObjects.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } else if (childNode.Name.LocalName == "fileRecoveryPr") { ctObj.fileRecoveryPr.Add(CT_FileRecoveryPr.Parse(childNode, namespaceManager)); } } return(ctObj); }