public static CT_SheetPr Parse(XmlNode node, XmlNamespaceManager namespaceManager)
{
if (node == null)
{
return(null);
}
CT_SheetPr ctObj = new CT_SheetPr();
ctObj.syncHorizontal = XmlHelper.ReadBool(node.Attributes["syncHorizontal"]);
ctObj.syncVertical = XmlHelper.ReadBool(node.Attributes["syncVertical"]);
ctObj.syncRef = XmlHelper.ReadString(node.Attributes["syncRef"]);
ctObj.transitionEvaluation = XmlHelper.ReadBool(node.Attributes["transitionEvaluation"]);
ctObj.transitionEntry = XmlHelper.ReadBool(node.Attributes["transitionEntry"]);
ctObj.published = XmlHelper.ReadBool(node.Attributes["published"]);
ctObj.codeName = XmlHelper.ReadString(node.Attributes["codeName"]);
ctObj.filterMode = XmlHelper.ReadBool(node.Attributes["filterMode"]);
ctObj.enableFormatConditionsCalculation = XmlHelper.ReadBool(node.Attributes["enableFormatConditionsCalculation"]);
foreach (XmlNode childNode in node.ChildNodes)
{
if (childNode.LocalName == "tabColor")
{
ctObj.tabColor = CT_Color.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "outlinePr")
{
ctObj.outlinePr = CT_OutlinePr.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "pageSetUpPr")
{
ctObj.pageSetUpPr = CT_PageSetUpPr.Parse(childNode, namespaceManager);
}
}
return(ctObj);
}
public CT_SheetPr Clone()
{
CT_SheetPr newPr = new CT_SheetPr();
newPr.codeNameField = codeNameField;
newPr.enableFormatConditionsCalculationField = enableFormatConditionsCalculationField;
newPr.filterModeField = filterModeField;
newPr.publishedField = publishedField;
newPr.syncHorizontalField = syncHorizontalField;
newPr.syncRefField = syncRefField;
newPr.syncVerticalField = syncVerticalField;
newPr.transitionEntryField = transitionEntryField;
newPr.transitionEvaluationField = transitionEvaluationField;
if (outlinePrField != null)
{
newPr.outlinePrField = outlinePrField.Clone();
}
if (pageSetUpPrField != null)
{
newPr.pageSetUpPrField = pageSetUpPrField.Clone();
}
if (tabColorField != null)
{
newPr.tabColorField = tabColorField.Copy();
}
return(newPr);
}
public static CT_SheetPr Parse(XmlNode node, XmlNamespaceManager namespaceManager)
{
if (node == null)
return null;
CT_SheetPr ctObj = new CT_SheetPr();
ctObj.syncHorizontal = XmlHelper.ReadBool(node.Attributes["syncHorizontal"]);
ctObj.syncVertical = XmlHelper.ReadBool(node.Attributes["syncVertical"]);
ctObj.syncRef = XmlHelper.ReadString(node.Attributes["syncRef"]);
ctObj.transitionEvaluation = XmlHelper.ReadBool(node.Attributes["transitionEvaluation"]);
ctObj.transitionEntry = XmlHelper.ReadBool(node.Attributes["transitionEntry"]);
ctObj.published = XmlHelper.ReadBool(node.Attributes["published"]);
ctObj.codeName = XmlHelper.ReadString(node.Attributes["codeName"]);
ctObj.filterMode = XmlHelper.ReadBool(node.Attributes["filterMode"]);
ctObj.enableFormatConditionsCalculation = XmlHelper.ReadBool(node.Attributes["enableFormatConditionsCalculation"]);
foreach (XmlNode childNode in node.ChildNodes)
{
if (childNode.LocalName == "tabColor")
ctObj.tabColor = CT_Color.Parse(childNode, namespaceManager);
else if (childNode.LocalName == "outlinePr")
ctObj.outlinePr = CT_OutlinePr.Parse(childNode, namespaceManager);
else if (childNode.LocalName == "pageSetUpPr")
ctObj.pageSetUpPr = CT_PageSetUpPr.Parse(childNode, namespaceManager);
}
return ctObj;
}
public CT_SheetPr AddNewSheetPr()
{
this.sheetPrField = new CT_SheetPr();
return(sheetPrField);
}
public static CT_Worksheet Parse(XmlNode 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 (XmlNode childNode in node.ChildNodes)
{
if (childNode.LocalName == "sheetPr")
{
ctObj.sheetPr = CT_SheetPr.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "dimension")
{
ctObj.dimension = CT_SheetDimension.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "sheetViews")
{
ctObj.sheetViews = CT_SheetViews.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "sheetFormatPr")
{
ctObj.sheetFormatPr = CT_SheetFormatPr.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "sheetData")
{
ctObj.sheetData = CT_SheetData.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "sheetCalcPr")
{
ctObj.sheetCalcPr = CT_SheetCalcPr.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "sheetProtection")
{
ctObj.sheetProtection = CT_SheetProtection.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "protectedRanges")
{
ctObj.protectedRanges = CT_ProtectedRanges.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "scenarios")
{
ctObj.scenarios = CT_Scenarios.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "autoFilter")
{
ctObj.autoFilter = CT_AutoFilter.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "sortState")
{
ctObj.sortState = CT_SortState.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "dataConsolidate")
{
ctObj.dataConsolidate = CT_DataConsolidate.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "customSheetViews")
{
ctObj.customSheetViews = CT_CustomSheetViews.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "mergeCells")
{
ctObj.mergeCells = CT_MergeCells.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "phoneticPr")
{
ctObj.phoneticPr = CT_PhoneticPr.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "dataValidations")
{
ctObj.dataValidations = CT_DataValidations.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "hyperlinks")
{
ctObj.hyperlinks = CT_Hyperlinks.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "printOptions")
{
ctObj.printOptions = CT_PrintOptions.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "pageMargins")
{
ctObj.pageMargins = CT_PageMargins.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "pageSetup")
{
ctObj.pageSetup = CT_PageSetup.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "headerFooter")
{
ctObj.headerFooter = CT_HeaderFooter.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "rowBreaks")
{
ctObj.rowBreaks = CT_PageBreak.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "colBreaks")
{
ctObj.colBreaks = CT_PageBreak.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "customProperties")
{
ctObj.customProperties = CT_CustomProperties.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "cellWatches")
{
ctObj.cellWatches = CT_CellWatches.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "ignoredErrors")
{
ctObj.ignoredErrors = CT_IgnoredErrors.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "smartTags")
{
ctObj.smartTags = CT_CellSmartTags.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "drawing")
{
ctObj.drawing = CT_Drawing.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "legacyDrawing")
{
ctObj.legacyDrawing = CT_LegacyDrawing.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "legacyDrawingHF")
{
ctObj.legacyDrawingHF = CT_LegacyDrawing.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "picture")
{
ctObj.picture = CT_SheetBackgroundPicture.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "oleObjects")
{
ctObj.oleObjects = CT_OleObjects.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "controls")
{
ctObj.controls = CT_Controls.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "webPublishItems")
{
ctObj.webPublishItems = CT_WebPublishItems.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "tableParts")
{
ctObj.tableParts = CT_TableParts.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "extLst")
{
ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "cols")
{
ctObj.cols.Add(CT_Cols.Parse(childNode, namespaceManager));
}
else if (childNode.LocalName == "conditionalFormatting")
{
ctObj.conditionalFormatting.Add(CT_ConditionalFormatting.Parse(childNode, namespaceManager));
}
}
return(ctObj);
}
public CT_SheetPr AddNewSheetPr()
{
this.sheetPrField = new CT_SheetPr();
return sheetPrField;
}
public CT_Macrosheet()
{
this.extLstField = new CT_ExtensionList();
this.oleObjectsField = new List<CT_OleObject>();
this.pictureField = new CT_SheetBackgroundPicture();
this.legacyDrawingHFField = new CT_LegacyDrawing();
this.legacyDrawingField = new CT_LegacyDrawing();
this.drawingField = new CT_Drawing();
this.customPropertiesField = new List<CT_CustomProperty>();
this.colBreaksField = new CT_PageBreak();
this.rowBreaksField = new CT_PageBreak();
this.headerFooterField = new CT_HeaderFooter();
this.pageSetupField = new CT_PageSetup();
this.pageMarginsField = new CT_PageMargins();
this.printOptionsField = new CT_PrintOptions();
this.conditionalFormattingField = new List<CT_ConditionalFormatting>();
this.phoneticPrField = new CT_PhoneticPr();
this.customSheetViewsField = new List<CT_CustomSheetView>();
this.dataConsolidateField = new CT_DataConsolidate();
this.sortStateField = new CT_SortState();
this.autoFilterField = new CT_AutoFilter();
this.sheetProtectionField = new CT_SheetProtection();
this.sheetDataField = new List<CT_Row>();
this.colsField = new List<CT_Col>();
this.sheetFormatPrField = new CT_SheetFormatPr();
this.sheetViewsField = new CT_SheetViews();
this.dimensionField = new CT_SheetDimension();
this.sheetPrField = new CT_SheetPr();
}