public CT_WorkbookPr AddNewWorkbookPr()
{
this.workbookPrField = new CT_WorkbookPr();
return(this.workbookPrField);
}
public static CT_WorkbookPr Parse(XmlNode node, XmlNamespaceManager namespaceManager)
{
if (node == null)
{
return(null);
}
CT_WorkbookPr ctObj = new CT_WorkbookPr();
ctObj.date1904 = XmlHelper.ReadBool(node.Attributes["date1904"]);
ctObj.date1904Specified = node.Attributes["date1904"] != null;
if (node.Attributes["showObjects"] != null)
{
ctObj.showObjects = (ST_Objects)Enum.Parse(typeof(ST_Objects), node.Attributes["showObjects"].Value);
}
ctObj.showBorderUnselectedTables = XmlHelper.ReadBool(node.Attributes["showBorderUnselectedTables"], true);
ctObj.filterPrivacy = XmlHelper.ReadBool(node.Attributes["filterPrivacy"]);
ctObj.promptedSolutions = XmlHelper.ReadBool(node.Attributes["promptedSolutions"]);
ctObj.showInkAnnotation = XmlHelper.ReadBool(node.Attributes["showInkAnnotation"], true);
ctObj.backupFile = XmlHelper.ReadBool(node.Attributes["backupFile"]);
ctObj.saveExternalLinkValues = XmlHelper.ReadBool(node.Attributes["saveExternalLinkValues"], true);
if (node.Attributes["updateLinks"] != null)
{
ctObj.updateLinks = (ST_UpdateLinks)Enum.Parse(typeof(ST_UpdateLinks), node.Attributes["updateLinks"].Value);
}
ctObj.codeName = XmlHelper.ReadString(node.Attributes["codeName"]);
ctObj.hidePivotFieldList = XmlHelper.ReadBool(node.Attributes["hidePivotFieldList"]);
ctObj.showPivotChartFilter = XmlHelper.ReadBool(node.Attributes["showPivotChartFilter"]);
ctObj.allowRefreshQuery = XmlHelper.ReadBool(node.Attributes["allowRefreshQuery"]);
ctObj.publishItems = XmlHelper.ReadBool(node.Attributes["publishItems"]);
ctObj.checkCompatibility = XmlHelper.ReadBool(node.Attributes["checkCompatibility"]);
ctObj.autoCompressPictures = XmlHelper.ReadBool(node.Attributes["autoCompressPictures"], false);
ctObj.refreshAllConnections = XmlHelper.ReadBool(node.Attributes["refreshAllConnections"]);
ctObj.defaultThemeVersion = XmlHelper.ReadUInt(node.Attributes["defaultThemeVersion"]);
return(ctObj);
}
public static CT_WorkbookPr Parse(XmlNode node, XmlNamespaceManager namespaceManager)
{
if (node == null)
return null;
CT_WorkbookPr ctObj = new CT_WorkbookPr();
ctObj.date1904 = XmlHelper.ReadBool(node.Attributes["date1904"]);
ctObj.date1904Specified = node.Attributes["date1904"]!=null;
if (node.Attributes["showObjects"] != null)
ctObj.showObjects = (ST_Objects)Enum.Parse(typeof(ST_Objects), node.Attributes["showObjects"].Value);
ctObj.showBorderUnselectedTables = XmlHelper.ReadBool(node.Attributes["showBorderUnselectedTables"], true);
ctObj.filterPrivacy = XmlHelper.ReadBool(node.Attributes["filterPrivacy"]);
ctObj.promptedSolutions = XmlHelper.ReadBool(node.Attributes["promptedSolutions"]);
ctObj.showInkAnnotation = XmlHelper.ReadBool(node.Attributes["showInkAnnotation"], true);
ctObj.backupFile = XmlHelper.ReadBool(node.Attributes["backupFile"]);
ctObj.saveExternalLinkValues = XmlHelper.ReadBool(node.Attributes["saveExternalLinkValues"], true);
if (node.Attributes["updateLinks"] != null)
ctObj.updateLinks = (ST_UpdateLinks)Enum.Parse(typeof(ST_UpdateLinks), node.Attributes["updateLinks"].Value);
ctObj.codeName = XmlHelper.ReadString(node.Attributes["codeName"]);
ctObj.hidePivotFieldList = XmlHelper.ReadBool(node.Attributes["hidePivotFieldList"]);
ctObj.showPivotChartFilter = XmlHelper.ReadBool(node.Attributes["showPivotChartFilter"]);
ctObj.allowRefreshQuery = XmlHelper.ReadBool(node.Attributes["allowRefreshQuery"]);
ctObj.publishItems = XmlHelper.ReadBool(node.Attributes["publishItems"]);
ctObj.checkCompatibility = XmlHelper.ReadBool(node.Attributes["checkCompatibility"]);
ctObj.autoCompressPictures = XmlHelper.ReadBool(node.Attributes["autoCompressPictures"], true);
ctObj.refreshAllConnections = XmlHelper.ReadBool(node.Attributes["refreshAllConnections"]);
ctObj.defaultThemeVersion = XmlHelper.ReadUInt(node.Attributes["defaultThemeVersion"]);
return ctObj;
}
public static CT_Workbook Parse(XmlNode node, XmlNamespaceManager namespaceManager)
{
if (node == null)
{
return(null);
}
CT_Workbook ctObj = new CT_Workbook();
ctObj.fileRecoveryPr = new List <CT_FileRecoveryPr>();
foreach (XmlNode childNode in node.ChildNodes)
{
if (childNode.LocalName == "fileVersion")
{
ctObj.fileVersion = CT_FileVersion.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "fileSharing")
{
ctObj.fileSharing = CT_FileSharing.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "workbookPr")
{
ctObj.workbookPr = CT_WorkbookPr.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "workbookProtection")
{
ctObj.workbookProtection = CT_WorkbookProtection.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "bookViews")
{
ctObj.bookViews = CT_BookViews.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "sheets")
{
ctObj.sheets = CT_Sheets.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "functionGroups")
{
ctObj.functionGroups = CT_FunctionGroups.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "externalReferences")
{
ctObj.externalReferences = CT_ExternalReferences.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "definedNames")
{
ctObj.definedNames = CT_DefinedNames.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "calcPr")
{
ctObj.calcPr = CT_CalcPr.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "oleSize")
{
ctObj.oleSize = CT_OleSize.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "customWorkbookViews")
{
ctObj.customWorkbookViews = CT_CustomWorkbookViews.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "pivotCaches")
{
ctObj.pivotCaches = CT_PivotCaches.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "smartTagPr")
{
ctObj.smartTagPr = CT_SmartTagPr.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "smartTagTypes")
{
ctObj.smartTagTypes = CT_SmartTagTypes.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "webPublishing")
{
ctObj.webPublishing = CT_WebPublishing.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "webPublishObjects")
{
ctObj.webPublishObjects = CT_WebPublishObjects.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "extLst")
{
ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager);
}
else if (childNode.LocalName == "fileRecoveryPr")
{
ctObj.fileRecoveryPr.Add(CT_FileRecoveryPr.Parse(childNode, namespaceManager));
}
}
return(ctObj);
}
public CT_WorkbookPr AddNewWorkbookPr()
{
this.workbookPrField = new CT_WorkbookPr();
return this.workbookPrField;
}
