public static CT_DefinedNames Parse(XmlNode node, XmlNamespaceManager namespaceManager)
{
if (node == null)
{
return(null);
}
CT_DefinedNames ctObj = new CT_DefinedNames();
ctObj.definedName = new List <CT_DefinedName>();
foreach (XmlNode childNode in node.ChildNodes)
{
if (childNode.LocalName == "definedName")
{
ctObj.definedName.Add(CT_DefinedName.Parse(childNode, namespaceManager));
}
}
return(ctObj);
}
/**
* marshal named ranges from the {@link #namedRanges} collection to the underlying CT_Workbook bean
*/
private void SaveNamedRanges()
{
// Named ranges
if (namedRanges.Count > 0)
{
CT_DefinedNames names = new CT_DefinedNames();
List<CT_DefinedName> nr = new List<CT_DefinedName>(namedRanges.Count);
foreach (XSSFName name in namedRanges)
{
nr.Add(name.GetCTName());
}
names.SetDefinedNameArray(nr);
if (workbook.IsSetDefinedNames())
{
workbook.unsetDefinedNames();
}
workbook.SetDefinedNames(names);
// Re-process the named ranges
ReprocessNamedRanges();
}
else
{
if (workbook.IsSetDefinedNames())
{
workbook.unsetDefinedNames();
}
}
}
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);
}
//AddNewWorkbookView()
public void SetDefinedNames(CT_DefinedNames definedNames)
{
this.definedNamesField = definedNames;
}
public void unsetDefinedNames()
{
this.definedNamesField = null;
}
public CT_DefinedNames AddNewDefinedNames()
{
this.definedNamesField = new CT_DefinedNames();
return(this.definedNamesField);
}
public void unsetDefinedNames()
{
this.definedNamesField = null;
}
//AddNewWorkbookView()
public void SetDefinedNames(CT_DefinedNames definedNames)
{
this.definedNamesField = definedNames;
}
public CT_DefinedNames AddNewDefinedNames()
{
this.definedNamesField = new CT_DefinedNames();
return this.definedNamesField;
}
public static CT_DefinedNames Parse(XmlNode node, XmlNamespaceManager namespaceManager)
{
if (node == null)
return null;
CT_DefinedNames ctObj = new CT_DefinedNames();
ctObj.definedName = new List<CT_DefinedName>();
foreach (XmlNode childNode in node.ChildNodes)
{
if (childNode.LocalName == "definedName")
ctObj.definedName.Add(CT_DefinedName.Parse(childNode, namespaceManager));
}
return ctObj;
}
