Example #1
0
 public void SetSheetViewArray(int index, CT_SheetView array)
 {
     sheetViewField[index] = array;
 }
Example #2
0
 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;
 }
Example #3
0
 public CT_SheetView AddNewSheetView()
 {
     CT_SheetView sv = new CT_SheetView();
     this.sheetViewField.Add(sv);
     return sv;
 }