public void Set(CT_Sheet sheet) { this.nameField = sheet.nameField; this.sheetIdField = sheet.sheetIdField; this.stateField = sheet.stateField; this.idField = sheet.idField; }
public CT_Sheet InsertNewSheet(int index) { if (this.sheetField == null) this.sheetField = new List<CT_Sheet>(); CT_Sheet newsheet = new CT_Sheet(); this.sheetField.Insert(index, newsheet); return newsheet; }
public CT_Sheet AddNewSheet() { if (this.sheetField == null) this.sheetField = new List<CT_Sheet>(); CT_Sheet newsheet = new CT_Sheet(); this.sheetField.Add(newsheet); return newsheet; }
public CT_Sheet Copy() { CT_Sheet obj = new CT_Sheet(); obj.idField = this.idField; obj.nameField = this.nameField; obj.stateField = this.stateField; return obj; }
public CT_Sheet Copy() { CT_Sheet obj = new CT_Sheet(); obj.idField = this.idField; obj.nameField = this.nameField; obj.stateField = this.stateField; return(obj); }
public CT_Sheet InsertNewSheet(int index) { if (this.sheetField == null) { this.sheetField = new List <CT_Sheet>(); } CT_Sheet newsheet = new CT_Sheet(); this.sheetField.Insert(index, newsheet); return(newsheet); }
public CT_Sheet AddNewSheet() { if (this.sheetField == null) { this.sheetField = new List <CT_Sheet>(); } CT_Sheet newsheet = new CT_Sheet(); this.sheetField.Add(newsheet); return(newsheet); }
public static CT_Sheet Parse(XmlNode node, XmlNamespaceManager namespaceManager) { if (node == null) return null; CT_Sheet ctObj = new CT_Sheet(); ctObj.name = XmlHelper.ReadString(node.Attributes["name"]); ctObj.sheetId = XmlHelper.ReadUInt(node.Attributes["sheetId"]); if (node.Attributes["state"] != null) ctObj.state = (ST_SheetState)Enum.Parse(typeof(ST_SheetState), node.Attributes["state"].Value); ctObj.id = XmlHelper.ReadString(node.Attributes["id", PackageNamespaces.SCHEMA_RELATIONSHIPS]); return ctObj; }
public static CT_Sheet Parse(XmlNode node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Sheet ctObj = new CT_Sheet(); ctObj.name = XmlHelper.ReadString(node.Attributes["name"]); ctObj.sheetId = XmlHelper.ReadUInt(node.Attributes["sheetId"]); if (node.Attributes["state"] != null) { ctObj.state = (ST_SheetState)Enum.Parse(typeof(ST_SheetState), node.Attributes["state"].Value); } ctObj.id = XmlHelper.ReadString(node.Attributes["id", PackageNamespaces.SCHEMA_RELATIONSHIPS]); return(ctObj); }
public static CT_Sheets Parse(XmlNode node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Sheets ctObj = new CT_Sheets(); ctObj.sheet = new List <CT_Sheet>(); foreach (XmlNode childNode in node.ChildNodes) { if (childNode.LocalName == "sheet") { ctObj.sheet.Add(CT_Sheet.Parse(childNode, namespaceManager)); } } return(ctObj); }
public void SerializeWorksheetDocumentTest() { CT_Workbook worksheet = new CT_Workbook(); CT_Sheet sheet1 = new CT_Sheet(); sheet1.name = "Sheet1"; sheet1.sheetId = 1u; sheet1.id = "rId1"; worksheet.sheets.sheet.Add(sheet1); var bks = worksheet.AddNewBookViews(); var bk = bks.AddNewWorkbookView(); bk.xWindow = 360; bk.xWindowSpecified = true; bk.yWindow = 60; bk.yWindowSpecified = true; bk.windowWidth = 11295; bk.windowWidthSpecified = true; bk.windowHeight = 5580; bk.windowHeightSpecified = true; StringWriter stream = new StringWriter(); WorkbookDocument_Accessor.serializer.Serialize(stream, worksheet, WorkbookDocument_Accessor.namespaces); string expected = @"<?xml version=""1.0"" encoding=""utf-16""?> <workbook xmlns:r=""http://schemas.openxmlformats.org/officeDocument/2006/relationships"" xmlns=""http://schemas.openxmlformats.org/spreadsheetml/2006/main""> <bookViews> <workbookView xWindow=""360"" yWindow=""60"" windowWidth=""11295"" windowHeight=""5580"" /> </bookViews> <sheets> <sheet name=""Sheet1"" sheetId=""1"" r:id=""rId1"" /> </sheets> </workbook>"; Assert.AreEqual(expected, stream.ToString()); }
public CT_Sheet InsertNewSheet(int index) { CT_Sheet newsheet = new CT_Sheet(); this.sheetField.Insert(index, newsheet); return newsheet; }
public CT_Sheet AddNewSheet() { CT_Sheet newsheet = new CT_Sheet(); this.sheetField.Add(newsheet); return newsheet; }