public XSSFTable() : base() { ctTable = new CT_Table(); }
public static TableDocument Parse(XmlDocument xmldoc, XmlNamespaceManager namespaceMgr) { CT_Table obj = new CT_Table(); XmlElement tableNode = xmldoc.DocumentElement; obj.id = XmlHelper.ReadUInt(tableNode.Attributes["id"]); obj.name = XmlHelper.ReadString(tableNode.Attributes["name"]); obj.displayName = XmlHelper.ReadString(tableNode.Attributes["displayName"]); if (tableNode.Attributes["tableType"] != null) { obj.tableType = (ST_TableType)Enum.Parse(typeof(ST_TableType), tableNode.Attributes["tableType"].Value); } obj.totalsRowCount = XmlHelper.ReadUInt(tableNode.GetAttributeNode("totalsRowCount")); obj.totalsRowShown = XmlHelper.ReadBool(tableNode.GetAttributeNode("totalsRowShown")); obj.@ref = XmlHelper.ReadString(tableNode.Attributes["ref"]); XmlNode autoFilter = xmldoc.SelectSingleNode("//d:autoFilter", namespaceMgr); if (autoFilter != null) { obj.autoFilter = new CT_AutoFilter(); obj.autoFilter.@ref = XmlHelper.ReadString(autoFilter.Attributes["name"]); } XmlNodeList tableCols = xmldoc.SelectNodes("//d:tableColumns/d:tableColumn", namespaceMgr); if (tableCols != null) { obj.tableColumns = new CT_TableColumns(); obj.tableColumns.count = (uint)tableCols.Count; foreach (XmlElement tableColNode in tableCols) { CT_TableColumn ctTableCol = new CT_TableColumn(); ctTableCol.id = XmlHelper.ReadUInt(tableColNode.GetAttributeNode("id")); ctTableCol.name = XmlHelper.ReadString(tableColNode.GetAttributeNode("name")); ctTableCol.uniqueName = XmlHelper.ReadString(tableColNode.GetAttributeNode("uniqueName")); ctTableCol.totalsRowCellStyle = XmlHelper.ReadString(tableColNode.GetAttributeNode("totalsRowCellStyle")); ctTableCol.totalsRowDxfId = XmlHelper.ReadUInt(tableColNode.GetAttributeNode("totalsRowDxfId")); ctTableCol.totalsRowLabel = XmlHelper.ReadString(tableColNode.GetAttributeNode("totalsRowDxfId")); ctTableCol.queryTableFieldId = XmlHelper.ReadUInt(tableColNode.GetAttributeNode("queryTableFieldId")); ctTableCol.xmlColumnPr = CT_XmlColumnPr.Parse(tableColNode.SelectSingleNode("d:xmlColumnPr", namespaceMgr), namespaceMgr); //TODO: parse sub element of CT_TableColumn obj.tableColumns.tableColumn.Add(ctTableCol); } } XmlNode tableStyleInfo = xmldoc.SelectSingleNode("//d:tableStyleInfo", namespaceMgr); if (tableStyleInfo != null) { obj.tableStyleInfo = new CT_TableStyleInfo(); obj.tableStyleInfo.name = XmlHelper.ReadString(tableStyleInfo.Attributes["name"]); obj.tableStyleInfo.showFirstColumn = XmlHelper.ReadBool(tableStyleInfo.Attributes["showFirstColumn"]); obj.tableStyleInfo.showLastColumn = XmlHelper.ReadBool(tableStyleInfo.Attributes["showLastColumn"]); obj.tableStyleInfo.showRowStripes = XmlHelper.ReadBool(tableStyleInfo.Attributes["showRowStripes"]); obj.tableStyleInfo.showColumnStripes = XmlHelper.ReadBool(tableStyleInfo.Attributes["showColumnStripes"]); } return(new TableDocument(obj)); }
public void ReadFrom(XmlDocument xmlDoc) { try { TableDocument doc = TableDocument.Parse(xmlDoc, NamespaceManager); ctTable = doc.GetTable(); } catch (XmlException e) { throw new IOException(e.Message); } }
public void ReadFrom(Stream is1) { try { TableDocument doc = TableDocument.Parse(is1); ctTable = doc.GetTable(); } catch (XmlException e) { throw new IOException(e.Message); } }
public static TableDocument Parse(XmlDocument xmldoc, XmlNamespaceManager namespaceMgr) { CT_Table obj = new CT_Table(); XmlElement tableNode = xmldoc.DocumentElement; obj.id = XmlHelper.ReadUInt(tableNode.Attributes["id"]); obj.name = XmlHelper.ReadString(tableNode.Attributes["name"]); obj.displayName = XmlHelper.ReadString(tableNode.Attributes["displayName"]); if (tableNode.Attributes["tableType"] != null) { obj.tableType = (ST_TableType)Enum.Parse(typeof(ST_TableType), tableNode.Attributes["tableType"].Value); } obj.totalsRowCount = XmlHelper.ReadUInt(tableNode.GetAttributeNode("totalsRowCount")); obj.totalsRowShown = XmlHelper.ReadBool(tableNode.GetAttributeNode("totalsRowShown")); obj.@ref = XmlHelper.ReadString(tableNode.Attributes["ref"]); XmlNode autoFilter = xmldoc.SelectSingleNode("//d:autoFilter", namespaceMgr); if (autoFilter != null) { obj.autoFilter = new CT_AutoFilter(); obj.autoFilter.@ref = XmlHelper.ReadString(autoFilter.Attributes["name"]); } XmlNodeList tableCols = xmldoc.SelectNodes("//d:tableColumns/d:tableColumn", namespaceMgr); if (tableCols != null) { obj.tableColumns = new CT_TableColumns(); obj.tableColumns.count = (uint)tableCols.Count; foreach (XmlElement tableColNode in tableCols) { CT_TableColumn ctTableCol = new CT_TableColumn(); ctTableCol.id = XmlHelper.ReadUInt(tableColNode.GetAttributeNode("id")); ctTableCol.name = XmlHelper.ReadString(tableColNode.GetAttributeNode("name")); ctTableCol.uniqueName = XmlHelper.ReadString(tableColNode.GetAttributeNode("uniqueName")); ctTableCol.totalsRowCellStyle = XmlHelper.ReadString(tableColNode.GetAttributeNode("totalsRowCellStyle")); ctTableCol.totalsRowDxfId = XmlHelper.ReadUInt(tableColNode.GetAttributeNode("totalsRowDxfId")); ctTableCol.totalsRowLabel = XmlHelper.ReadString(tableColNode.GetAttributeNode("totalsRowDxfId")); ctTableCol.queryTableFieldId = XmlHelper.ReadUInt(tableColNode.GetAttributeNode("queryTableFieldId")); ctTableCol.xmlColumnPr = CT_XmlColumnPr.Parse(tableColNode.SelectSingleNode("d:xmlColumnPr", namespaceMgr), namespaceMgr); //TODO: parse sub element of CT_TableColumn obj.tableColumns.tableColumn.Add(ctTableCol); } } XmlNode tableStyleInfo = xmldoc.SelectSingleNode("//d:tableStyleInfo", namespaceMgr); if (tableStyleInfo != null) { obj.tableStyleInfo = new CT_TableStyleInfo(); obj.tableStyleInfo.name = XmlHelper.ReadString(tableStyleInfo.Attributes["name"]); obj.tableStyleInfo.showFirstColumn = XmlHelper.ReadBool(tableStyleInfo.Attributes["showFirstColumn"]); obj.tableStyleInfo.showLastColumn = XmlHelper.ReadBool(tableStyleInfo.Attributes["showLastColumn"]); obj.tableStyleInfo.showRowStripes = XmlHelper.ReadBool(tableStyleInfo.Attributes["showRowStripes"]); obj.tableStyleInfo.showColumnStripes = XmlHelper.ReadBool(tableStyleInfo.Attributes["showColumnStripes"]); } return new TableDocument(obj); }
public static TableDocument Parse(XmlDocument xmldoc, XmlNamespaceManager namespaceMgr) { CT_Table obj = new CT_Table(); XmlNode tableNode = xmldoc.DocumentElement; obj.id = uint.Parse(tableNode.Attributes["id"].Value); obj.name = tableNode.Attributes["name"].Value; obj.displayName = tableNode.Attributes["displayName"].Value; if (tableNode.Attributes["tableType"] != null) { obj.tableType = (ST_TableType)Enum.Parse(typeof(ST_TableType), tableNode.Attributes["tableType"].Value); } if (tableNode.Attributes["totalsRowCount"] != null) obj.totalsRowCount = uint.Parse(tableNode.Attributes["totalsRowCount"].Value); if(tableNode.Attributes["totalsRowShown"].Value=="1"||tableNode.Attributes["totalsRowShown"].Value.ToLower()=="true") obj.totalsRowShown = true; obj.@ref = tableNode.Attributes["ref"].Value; var autoFilter = xmldoc.SelectSingleNode("//d:autoFilter", namespaceMgr); if (autoFilter != null) { obj.autoFilter = new CT_AutoFilter(); obj.autoFilter.@ref = autoFilter.Attributes["ref"].Value; } var tableCols = xmldoc.SelectNodes("//d:tableColumns/d:tableColumn", namespaceMgr); if (tableCols != null) { obj.tableColumns = new CT_TableColumns(); obj.tableColumns.count = (uint)tableCols.Count; foreach (XmlNode tableCol in tableCols) { CT_TableColumn tableColObj = new CT_TableColumn(); tableColObj.id = uint.Parse(tableCol.Attributes["id"].Value); tableColObj.name = tableCol.Attributes["name"].Value; obj.tableColumns.tableColumn.Add(tableColObj); } } var tableStyleInfo = xmldoc.SelectSingleNode("//d:tableStyleInfo", namespaceMgr); if (tableStyleInfo != null) { obj.tableStyleInfo = new CT_TableStyleInfo(); obj.tableStyleInfo.name = tableStyleInfo.Attributes["name"].Value; if (tableStyleInfo.Attributes["showFirstColumn"] != null) obj.tableStyleInfo.showFirstColumn = tableStyleInfo.Attributes["showFirstColumn"].Value == "1" ? true : false; if (tableStyleInfo.Attributes["showLastColumn"] != null) obj.tableStyleInfo.showLastColumn = tableStyleInfo.Attributes["showLastColumn"].Value == "1" ? true : false; if (tableStyleInfo.Attributes["showRowStripes"] != null) obj.tableStyleInfo.showRowStripes = tableStyleInfo.Attributes["showRowStripes"].Value == "1" ? true : false; if (tableStyleInfo.Attributes["showColumnStripes"] != null) obj.tableStyleInfo.showColumnStripes = tableStyleInfo.Attributes["showColumnStripes"].Value == "1" ? true : false; } return new TableDocument(obj); }
public void SetTable(CT_Table table) { this.ctTable = table; }
public TableDocument(CT_Table table) { this.ctTable = table; }
public static CT_Table Parse(XmlNode node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Table ctObj = new CT_Table(); if (node.Attributes["id"] != null) { ctObj.id = XmlHelper.ReadUInt(node.Attributes["id"]); } ctObj.name = XmlHelper.ReadString(node.Attributes["name"]); ctObj.displayName = XmlHelper.ReadString(node.Attributes["displayName"]); ctObj.comment = XmlHelper.ReadString(node.Attributes["comment"]); ctObj.@ref = XmlHelper.ReadString(node.Attributes["ref"]); if (node.Attributes["tableType"] != null) { ctObj.tableType = (ST_TableType)Enum.Parse(typeof(ST_TableType), node.Attributes["tableType"].Value); } if (node.Attributes["headerRowCount"] != null) { ctObj.headerRowCount = XmlHelper.ReadUInt(node.Attributes["headerRowCount"]); } if (node.Attributes["insertRow"] != null) { ctObj.insertRow = XmlHelper.ReadBool(node.Attributes["insertRow"]); } if (node.Attributes["insertRowShift"] != null) { ctObj.insertRowShift = XmlHelper.ReadBool(node.Attributes["insertRowShift"]); } if (node.Attributes["totalsRowCount"] != null) { ctObj.totalsRowCount = XmlHelper.ReadUInt(node.Attributes["totalsRowCount"]); } if (node.Attributes["totalsRowShown"] != null) { ctObj.totalsRowShown = XmlHelper.ReadBool(node.Attributes["totalsRowShown"]); } if (node.Attributes["published"] != null) { ctObj.published = XmlHelper.ReadBool(node.Attributes["published"]); } if (node.Attributes["headerRowDxfId"] != null) { ctObj.headerRowDxfId = XmlHelper.ReadUInt(node.Attributes["headerRowDxfId"]); } if (node.Attributes["dataDxfId"] != null) { ctObj.dataDxfId = XmlHelper.ReadUInt(node.Attributes["dataDxfId"]); } if (node.Attributes["totalsRowDxfId"] != null) { ctObj.totalsRowDxfId = XmlHelper.ReadUInt(node.Attributes["totalsRowDxfId"]); } if (node.Attributes["headerRowBorderDxfId"] != null) { ctObj.headerRowBorderDxfId = XmlHelper.ReadUInt(node.Attributes["headerRowBorderDxfId"]); } if (node.Attributes["tableBorderDxfId"] != null) { ctObj.tableBorderDxfId = XmlHelper.ReadUInt(node.Attributes["tableBorderDxfId"]); } if (node.Attributes["totalsRowBorderDxfId"] != null) { ctObj.totalsRowBorderDxfId = XmlHelper.ReadUInt(node.Attributes["totalsRowBorderDxfId"]); } ctObj.headerRowCellStyle = XmlHelper.ReadString(node.Attributes["headerRowCellStyle"]); ctObj.dataCellStyle = XmlHelper.ReadString(node.Attributes["dataCellStyle"]); ctObj.totalsRowCellStyle = XmlHelper.ReadString(node.Attributes["totalsRowCellStyle"]); if (node.Attributes["connectionId"] != null) { ctObj.connectionId = XmlHelper.ReadUInt(node.Attributes["connectionId"]); } foreach (XmlNode childNode in node.ChildNodes) { if (childNode.LocalName == "autoFilter") { ctObj.autoFilter = CT_AutoFilter.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "sortState") { ctObj.sortState = CT_SortState.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "tableColumns") { ctObj.tableColumns = CT_TableColumns.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "tableStyleInfo") { ctObj.tableStyleInfo = CT_TableStyleInfo.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } } return(ctObj); }
public static CT_Table Parse(XmlNode node, XmlNamespaceManager namespaceManager) { if (node == null) return null; CT_Table ctObj = new CT_Table(); if (node.Attributes["id"] != null) ctObj.id = XmlHelper.ReadUInt(node.Attributes["id"]); ctObj.name = XmlHelper.ReadString(node.Attributes["name"]); ctObj.displayName = XmlHelper.ReadString(node.Attributes["displayName"]); ctObj.comment = XmlHelper.ReadString(node.Attributes["comment"]); ctObj.@ref = XmlHelper.ReadString(node.Attributes["ref"]); if (node.Attributes["tableType"] != null) ctObj.tableType = (ST_TableType)Enum.Parse(typeof(ST_TableType), node.Attributes["tableType"].Value); if (node.Attributes["headerRowCount"] != null) ctObj.headerRowCount = XmlHelper.ReadUInt(node.Attributes["headerRowCount"]); if (node.Attributes["insertRow"] != null) ctObj.insertRow = XmlHelper.ReadBool(node.Attributes["insertRow"]); if (node.Attributes["insertRowShift"] != null) ctObj.insertRowShift = XmlHelper.ReadBool(node.Attributes["insertRowShift"]); if (node.Attributes["totalsRowCount"] != null) ctObj.totalsRowCount = XmlHelper.ReadUInt(node.Attributes["totalsRowCount"]); if (node.Attributes["totalsRowShown"] != null) ctObj.totalsRowShown = XmlHelper.ReadBool(node.Attributes["totalsRowShown"]); if (node.Attributes["published"] != null) ctObj.published = XmlHelper.ReadBool(node.Attributes["published"]); if (node.Attributes["headerRowDxfId"] != null) ctObj.headerRowDxfId = XmlHelper.ReadUInt(node.Attributes["headerRowDxfId"]); if (node.Attributes["dataDxfId"] != null) ctObj.dataDxfId = XmlHelper.ReadUInt(node.Attributes["dataDxfId"]); if (node.Attributes["totalsRowDxfId"] != null) ctObj.totalsRowDxfId = XmlHelper.ReadUInt(node.Attributes["totalsRowDxfId"]); if (node.Attributes["headerRowBorderDxfId"] != null) ctObj.headerRowBorderDxfId = XmlHelper.ReadUInt(node.Attributes["headerRowBorderDxfId"]); if (node.Attributes["tableBorderDxfId"] != null) ctObj.tableBorderDxfId = XmlHelper.ReadUInt(node.Attributes["tableBorderDxfId"]); if (node.Attributes["totalsRowBorderDxfId"] != null) ctObj.totalsRowBorderDxfId = XmlHelper.ReadUInt(node.Attributes["totalsRowBorderDxfId"]); ctObj.headerRowCellStyle = XmlHelper.ReadString(node.Attributes["headerRowCellStyle"]); ctObj.dataCellStyle = XmlHelper.ReadString(node.Attributes["dataCellStyle"]); ctObj.totalsRowCellStyle = XmlHelper.ReadString(node.Attributes["totalsRowCellStyle"]); if (node.Attributes["connectionId"] != null) ctObj.connectionId = XmlHelper.ReadUInt(node.Attributes["connectionId"]); foreach (XmlNode childNode in node.ChildNodes) { if (childNode.LocalName == "autoFilter") ctObj.autoFilter = CT_AutoFilter.Parse(childNode, namespaceManager); else if (childNode.LocalName == "sortState") ctObj.sortState = CT_SortState.Parse(childNode, namespaceManager); else if (childNode.LocalName == "tableColumns") ctObj.tableColumns = CT_TableColumns.Parse(childNode, namespaceManager); else if (childNode.LocalName == "tableStyleInfo") ctObj.tableStyleInfo = CT_TableStyleInfo.Parse(childNode, namespaceManager); else if (childNode.LocalName == "extLst") ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } return ctObj; }
public static TableDocument Parse(Stream stream) { CT_Table obj = (CT_Table)serializer.Deserialize(stream); return(new TableDocument(obj)); }
public static TableDocument Parse(XmlDocument xmldoc, XmlNamespaceManager namespaceMgr) { CT_Table obj = CT_Table.Parse(xmldoc.DocumentElement, namespaceMgr); return(new TableDocument(obj)); }