public void SetSheetViewArray(int index, CT_SheetView array)
{
sheetViewField[index] = array;
}
public static CT_SheetView Parse(XmlNode node, XmlNamespaceManager namespaceManager)
{
if (node == null)
return null;
CT_SheetView ctObj = new CT_SheetView();
ctObj.windowProtection = XmlHelper.ReadBool(node.Attributes["windowProtection"]);
ctObj.showFormulas = XmlHelper.ReadBool(node.Attributes["showFormulas"]);
if (node.Attributes["showGridLines"] == null)
ctObj.showGridLines = true;
else
ctObj.showGridLines = XmlHelper.ReadBool(node.Attributes["showGridLines"]);
if (node.Attributes["showRowColHeaders"] == null)
ctObj.showRowColHeaders = true;
else
ctObj.showRowColHeaders = XmlHelper.ReadBool(node.Attributes["showRowColHeaders"]);
if (node.Attributes["showZeros"] == null)
ctObj.showZeros = true;
else
ctObj.showZeros = XmlHelper.ReadBool(node.Attributes["showZeros"]);
ctObj.rightToLeft = XmlHelper.ReadBool(node.Attributes["rightToLeft"]);
ctObj.tabSelected = XmlHelper.ReadBool(node.Attributes["tabSelected"]);
ctObj.showRuler = XmlHelper.ReadBool(node.Attributes["showRuler"]);
ctObj.showOutlineSymbols = XmlHelper.ReadBool(node.Attributes["showOutlineSymbols"]);
ctObj.defaultGridColor = XmlHelper.ReadBool(node.Attributes["defaultGridColor"]);
if (node.Attributes["showWhiteSpace"] == null)
ctObj.showWhiteSpace = true;
else
ctObj.showWhiteSpace = XmlHelper.ReadBool(node.Attributes["showWhiteSpace"]);
if (node.Attributes["view"] != null)
ctObj.view = (ST_SheetViewType)Enum.Parse(typeof(ST_SheetViewType), node.Attributes["view"].Value);
ctObj.topLeftCell = XmlHelper.ReadString(node.Attributes["topLeftCell"]);
ctObj.colorId = XmlHelper.ReadUInt(node.Attributes["colorId"]);
ctObj.zoomScale = XmlHelper.ReadUInt(node.Attributes["zoomScale"]);
ctObj.zoomScaleNormal = XmlHelper.ReadUInt(node.Attributes["zoomScaleNormal"]);
ctObj.zoomScaleSheetLayoutView = XmlHelper.ReadUInt(node.Attributes["zoomScaleSheetLayoutView"]);
ctObj.zoomScalePageLayoutView = XmlHelper.ReadUInt(node.Attributes["zoomScalePageLayoutView"]);
ctObj.workbookViewId = XmlHelper.ReadUInt(node.Attributes["workbookViewId"]);
ctObj.selection = new List<CT_Selection>();
ctObj.pivotSelection = new List<CT_PivotSelection>();
foreach (XmlNode childNode in node.ChildNodes)
{
if (childNode.LocalName == "pane")
ctObj.pane = CT_Pane.Parse(childNode, namespaceManager);
else if (childNode.LocalName == "extLst")
ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager);
else if (childNode.LocalName == "selection")
ctObj.selection.Add(CT_Selection.Parse(childNode, namespaceManager));
else if (childNode.LocalName == "pivotSelection")
ctObj.pivotSelection.Add(CT_PivotSelection.Parse(childNode, namespaceManager));
}
return ctObj;
}
public CT_SheetView AddNewSheetView()
{
CT_SheetView sv = new CT_SheetView();
this.sheetViewField.Add(sv);
return sv;
}