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 CT_FutureMetadataBlock()
{
this.extLstField = new CT_ExtensionList();
}
public CT_FutureMetadata()
{
this.extLstField = new CT_ExtensionList();
this.bkField = new List <CT_FutureMetadataBlock>();
this.countField = ((uint)(0));
}
public CT_XmlPr()
{
this.extLstField = new CT_ExtensionList();
}
public CT_SingleXmlCell()
{
this.extLstField = new CT_ExtensionList();
this.xmlCellPrField = new CT_XmlCellPr();
}
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_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);
}
public CT_SharedUser()
{
this.extLstField = new CT_ExtensionList();
}
