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 void SetUp() { stylesTable = new StylesTable(); ctStylesheet = stylesTable.GetCTStylesheet(); ctBorderA = new CT_Border(); XSSFCellBorder borderA = new XSSFCellBorder(ctBorderA); long borderId = stylesTable.PutBorder(borderA); Assert.AreEqual(1, borderId); XSSFCellBorder borderB = new XSSFCellBorder(); Assert.AreEqual(1, stylesTable.PutBorder(borderB)); ctFill = new CT_Fill(); XSSFCellFill fill = new XSSFCellFill(ctFill); long fillId = stylesTable.PutFill(fill); Assert.AreEqual(2, fillId); ctFont = new CT_Font(); XSSFFont font = new XSSFFont(ctFont); long fontId = stylesTable.PutFont(font); Assert.AreEqual(1, fontId); cellStyleXf = ctStylesheet.AddNewCellStyleXfs().AddNewXf(); cellStyleXf.borderId = 1; cellStyleXf.fillId = 1; cellStyleXf.fontId = 1; cellXfs = ctStylesheet.AddNewCellXfs(); cellXf = cellXfs.AddNewXf(); cellXf.xfId = (1); cellXf.borderId = (1); cellXf.fillId = (1); cellXf.fontId = (1); stylesTable.PutCellStyleXf(cellStyleXf); stylesTable.PutCellXf(cellXf); cellStyle = new XSSFCellStyle(1, 1, stylesTable, null); Assert.IsNotNull(stylesTable.GetFillAt(1).GetCTFill().patternFill); Assert.AreEqual(ST_PatternType.darkGray, stylesTable.GetFillAt(1).GetCTFill().patternFill.patternType); }
public void TestGetBorderStyle() { CT_Stylesheet stylesheet = new CT_Stylesheet(); CT_Border border = stylesheet.AddNewBorders().AddNewBorder(); CT_BorderPr top = border.AddNewTop(); CT_BorderPr right = border.AddNewRight(); CT_BorderPr bottom = border.AddNewBottom(); top.style = (ST_BorderStyle.dashDot); right.style = (ST_BorderStyle.none); bottom.style = (ST_BorderStyle.thin); XSSFCellBorder cellBorderStyle = new XSSFCellBorder(border); Assert.AreEqual("DashDot", cellBorderStyle.GetBorderStyle(BorderSide.TOP).ToString()); Assert.AreEqual("None", cellBorderStyle.GetBorderStyle(BorderSide.RIGHT).ToString()); Assert.AreEqual(BorderStyle.None, cellBorderStyle.GetBorderStyle(BorderSide.RIGHT)); Assert.AreEqual("Thin", cellBorderStyle.GetBorderStyle(BorderSide.BOTTOM).ToString()); Assert.AreEqual(BorderStyle.Thin, cellBorderStyle.GetBorderStyle(BorderSide.BOTTOM)); }
public void AddNewStyleSheet() { this.stylesheet = new CT_Stylesheet(); }
public static StyleSheetDocument Parse(XmlDocument xmldoc, XmlNamespaceManager nameSpaceManager) { CT_Stylesheet obj = CT_Stylesheet.Parse(xmldoc.DocumentElement, nameSpaceManager); return(new StyleSheetDocument(obj)); }
public StyleSheetDocument(CT_Stylesheet stylesheet) { this.stylesheet = stylesheet; }
public StyleSheetDocument() { this.stylesheet = new CT_Stylesheet(); }
public static StyleSheetDocument Parse(Stream stream) { CT_Stylesheet obj = (CT_Stylesheet)serializer.Deserialize(stream); return(new StyleSheetDocument(obj)); }