. :
public Stylesheet(params OpenXmlElement[] childElements);
, CellFormats OpenXmlElement. , ... , .
new CellFormats(
new CellFormat(new Alignment() { Horizontal = HorizontalAlignmentValues.Left, Vertical = VerticalAlignmentValues.Center })
{ FontId = 0, FillId = 0, BorderId = 0, ApplyBorder = true },
new CellFormat(new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center })
{ FontId = 1, FillId = 2, BorderId = 0, ApplyFont = true, ApplyBorder = true, ApplyFill = true },
new CellFormat(new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center })
{ FontId = 1, FillId = 0, BorderId = 0, ApplyFont = true, ApplyBorder = true, ApplyFill = true }
)
, , :
private enum CellStyleEnum
{
Value = 0,
Header = 1,
Error = 2
}
var cell = new Cell
{
DataType = CellValues.InlineString,
CellReference = header + index,
StyleIndex = (UInt32)CellStyleEnum.Header
};
source
share