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 void AddNewStyleSheet()
{
this.stylesheet = new CT_Stylesheet();
}
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));
}
