private NPOI.SS.UserModel.Cell CreateCell(Cell cell, Row currentRow, int columnOrdinal) { var nCell = currentRow.CreateCell(columnOrdinal, CellType.STRING); nCell.CellStyle = GetCellStyle(cell); return nCell; }
public void RichTextCell_should_have_default_value() { Cell target = new Cell(); Assert.IsFalse(target.IsBold); Assert.AreEqual(Color.Empty, target.BackgroundColor); Assert.IsNotNull(target.Borders); }
private CellStyle GetCellStyle(Cell cell) { CellStyle style = _sheet.Workbook.CreateCellStyle(); SetBold(cell, style); SetColor(cell, style); SetBorder(cell, style); return style; }
private void SetColor(Cell cell, CellStyle style) { if (cell.BackgroundColor != Color.Empty && cell.BackgroundColor != Color.White) { style.FillForegroundColor = cell.BackgroundColor.ToNPOIColor(); style.FillPattern = FillPatternType.SOLID_FOREGROUND; } }
private void SetBorder(Cell cell, CellStyle style) { foreach (var border in cell.Borders) { if (border.Location != BorderLocation.None) { switch (border.Location) { case BorderLocation.Top: style.BorderTop = border.Style.NPOIBorderType(); style.TopBorderColor = border.Color.ToNPOIColor(); break; case BorderLocation.Bottom: style.BorderBottom = border.Style.NPOIBorderType(); style.BottomBorderColor = border.Color.ToNPOIColor(); break; case BorderLocation.Left: style.BorderLeft = border.Style.NPOIBorderType(); style.LeftBorderColor = border.Color.ToNPOIColor(); break; case BorderLocation.Right: style.BorderRight = border.Style.NPOIBorderType(); style.RightBorderColor = border.Color.ToNPOIColor(); break; default: throw new InvalidOperationException("Trying to set border for non-existent side"); } } } }
private void SetBold(Cell cell, CellStyle style) { if (cell.IsBold) { Font font = _sheet.Workbook.CreateFont(); font.Boldweight = (short)FontBoldWeight.BOLD; style.SetFont(font); } }
public void Cell_should_have_default_values() { Cell target = new Cell(); Assert.AreEqual(1, target.ColumnSpan); }