public static CT_Stylesheet Parse(XmlNode node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Stylesheet ctObj = new CT_Stylesheet(); foreach (XmlNode childNode in node.ChildNodes) { if (childNode.LocalName == "numFmts") { ctObj.numFmts = CT_NumFmts.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "fonts") { ctObj.fonts = CT_Fonts.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "fills") { ctObj.fills = CT_Fills.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "borders") { ctObj.borders = CT_Borders.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "cellStyleXfs") { ctObj.cellStyleXfs = CT_CellStyleXfs.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "cellXfs") { ctObj.cellXfs = CT_CellXfs.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "cellStyles") { ctObj.cellStyles = CT_CellStyles.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "dxfs") { ctObj.dxfs = CT_Dxfs.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "tableStyles") { ctObj.tableStyles = CT_TableStyles.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "colors") { ctObj.colors = CT_Colors.Parse(childNode, namespaceManager); } else if (childNode.LocalName == "extLst") { ctObj.extLst = CT_ExtensionList.Parse(childNode, namespaceManager); } } return(ctObj); }
public static CT_Dxfs Parse(XmlNode node, XmlNamespaceManager namespaceManager) { if (node == null) return null; CT_Dxfs ctObj = new CT_Dxfs(); ctObj.count = XmlHelper.ReadUInt(node.Attributes["count"]); ctObj.dxf = new List<CT_Dxf>(); foreach (XmlNode childNode in node.ChildNodes) { if (childNode.LocalName == "dxf") ctObj.dxf.Add(CT_Dxf.Parse(childNode, namespaceManager)); } return ctObj; }
public static CT_Dxfs Parse(XmlNode node, XmlNamespaceManager namespaceManager) { if (node == null) { return(null); } CT_Dxfs ctObj = new CT_Dxfs(); ctObj.count = XmlHelper.ReadUInt(node.Attributes["count"]); ctObj.dxf = new List <CT_Dxf>(); foreach (XmlNode childNode in node.ChildNodes) { if (childNode.LocalName == "dxf") { ctObj.dxf.Add(CT_Dxf.Parse(childNode, namespaceManager)); } } return(ctObj); }
/** * Write this table out as XML. * * @param out The stream to write to. * @throws IOException if an error occurs while writing. */ public void WriteTo(Stream out1) { // Work on the current one // Need to do this, as we don't handle // all the possible entries yet CT_Stylesheet styleSheet = doc.GetStyleSheet(); // Formats CT_NumFmts ctFormats = new CT_NumFmts(); ctFormats.count = (uint)numberFormats.Count; if (ctFormats.count > 0) ctFormats.countSpecified = true; foreach (KeyValuePair<int, String> fmt in numberFormats) { CT_NumFmt ctFmt = ctFormats.AddNewNumFmt(); ctFmt.numFmtId = (uint)fmt.Key; ctFmt.formatCode = fmt.Value; } if (ctFormats.count>0) styleSheet.numFmts = ctFormats; // Fonts CT_Fonts ctFonts = styleSheet.fonts; if (ctFonts == null) ctFonts = new CT_Fonts(); ctFonts.count = (uint)fonts.Count; if (ctFonts.count > 0) ctFonts.countSpecified = true; List<CT_Font> ctfnt = new List<CT_Font>(fonts.Count); foreach (XSSFFont f in fonts) ctfnt.Add(f.GetCTFont()); ctFonts.SetFontArray(ctfnt); styleSheet.fonts = (ctFonts); // Fills CT_Fills ctFills = styleSheet.fills; if (ctFills == null) { ctFills = new CT_Fills(); } ctFills.count = (uint)fills.Count; List<CT_Fill> ctf = new List<CT_Fill>(fills.Count); foreach (XSSFCellFill f in fills) ctf.Add( f.GetCTFill()); ctFills.SetFillArray(ctf); if (ctFills.count > 0) ctFills.countSpecified = true; styleSheet.fills = ctFills; // Borders CT_Borders ctBorders = styleSheet.borders; if (ctBorders == null) { ctBorders = new CT_Borders(); } ctBorders.count = (uint)borders.Count; List<CT_Border> ctb = new List<CT_Border>(borders.Count); foreach (XSSFCellBorder b in borders) ctb.Add(b.GetCTBorder()); ctBorders.SetBorderArray(ctb); styleSheet.borders = ctBorders; // Xfs if (xfs.Count > 0) { CT_CellXfs ctXfs = styleSheet.cellXfs; if (ctXfs == null) { ctXfs = new CT_CellXfs(); } ctXfs.count = (uint)xfs.Count; if (ctXfs.count > 0) ctXfs.countSpecified = true; ctXfs.xf = xfs; styleSheet.cellXfs = (ctXfs); } // Style xfs if (styleXfs.Count > 0) { CT_CellStyleXfs ctSXfs = styleSheet.cellStyleXfs; if (ctSXfs == null) { ctSXfs = new CT_CellStyleXfs(); } ctSXfs.count = (uint)(styleXfs.Count); if (ctSXfs.count > 0) ctSXfs.countSpecified = true; ctSXfs.xf = styleXfs; styleSheet.cellStyleXfs = (ctSXfs); } // Style dxfs if (dxfs.Count > 0) { CT_Dxfs ctDxfs = styleSheet.dxfs; if (ctDxfs == null) { ctDxfs = new CT_Dxfs(); } ctDxfs.count = (uint)dxfs.Count; if (ctDxfs.count > 0) ctDxfs.countSpecified = true; ctDxfs.dxf = dxfs; styleSheet.dxfs = (ctDxfs); } // Save doc.Save(out1); }