public IWorkbook Decorate(IWorkbook workbook, DecoratorContext context) { if (context == null) { throw new ArgumentNullException("context"); } var attr = context.TypeDecoratorInfo.GetDecorateAttr <WrapTextAttribute>(); if (attr == null) { return(workbook); } ISheet sheet = workbook.GetSheetAt(0); IRow row; if (sheet.PhysicalNumberOfRows > 0) { for (int i = 0; i < sheet.PhysicalNumberOfRows; i++) { row = sheet.GetRow(i); for (int colIndex = 0; colIndex < row.PhysicalNumberOfCells; colIndex++) { row.GetCell(colIndex).CellStyle.WrapText = true; } } } return(workbook); }
public IWorkbook Decorate(IWorkbook workbook, DecoratorContext context) { if (context == null) { throw new ArgumentNullException("context"); } var attr = (HeaderAttribute)context.TypeDecoratorInfo.TypeDecoratorAttrs.SingleOrDefault(a => a.GetType() == typeof(HeaderAttribute)); if (attr == null) { return(workbook); } IRow headerRow = workbook.GetSheetAt(0).GetRow(0); ICellStyle style = workbook.CreateCellStyle(); IFont font = workbook.CreateFont(); font.FontName = attr.FontName; font.Color = (short)attr.Color.GetHashCode(); font.FontHeightInPoints = (short)attr.FontSize; if (attr.IsBold) { font.Boldweight = short.MaxValue; } style.SetFont(font); for (int i = 0; i < headerRow.PhysicalNumberOfCells; i++) { headerRow.GetCell(i).CellStyle = style; } return(workbook); }
private static void Decorate <T>() where T : class, new() { DecoratorContext context = new DecoratorContext() { TypeDecoratorInfo = TypeDecoratorInfoFactory.CreateInstance(typeof(T)) }; GetDecorators <T>().ForEach(d => { Workbook = d.Decorate(Workbook, context); }); }
public IWorkbook Decorate(IWorkbook workbook, DecoratorContext context) { if (context == null) { throw new ArgumentNullException("context"); } var propertyDecoratorInfos = context.TypeDecoratorInfo.PropertyDecoratorInfos; ISheet sheet = workbook.GetSheetAt(0); foreach (var item in propertyDecoratorInfos) { if (item.DecoratorAttrs.SingleOrDefault(a => a.GetType() == typeof(MergeColsAttribute)) != null) { InternalDecorate(sheet, item.ColIndex); } } return(workbook); }