internal IFont CreateFont(RowStyle rowStyle) { IColor color = CreateColor(rowStyle.FontColor); switch (ExcelVersion){ case ExcelVersion.XLS: var fontExcelXls = new XLSStrategyStyle(ExcelXls); return fontExcelXls.GetFont(rowStyle.FontSize, rowStyle.FontName, color); case ExcelVersion.XLSX: var fontExcelXlsx = new XLSXStrategyStyle(ExcelXlsx); return fontExcelXlsx.GetFont(rowStyle.FontSize, rowStyle.FontName, color); default: throw new Exception(ErrorMessage.Excel_BadVersion); } }
internal ICellStyle CreateCellStyle(RowStyle rowStyle) { IColor borderColor = CreateColor(rowStyle.BorderColor); IColor backColor = CreateColor(rowStyle.BackColor); IFont font = CreateFont(rowStyle); switch (ExcelVersion) { case ExcelVersion.XLS: var CellStyleXLS = new XLSStrategyStyle(ExcelXls); return CellStyleXLS.GetCellStyle(backColor, borderColor, font); case ExcelVersion.XLSX: var CellStyleXLSX = new XLSXStrategyStyle(ExcelXlsx); return CellStyleXLSX.GetCellStyle(backColor, borderColor, font); default: throw new Exception(ErrorMessage.Excel_BadVersion); } }
public static RowStyle GetHeadersFormat(Type type) { RowStyle rowStyle; var defaultFontName = "Calibry"; var defaultFontColor = "#FFFFFF"; short defaultFontSize = 11; var defaultBorderColor = "#000000"; var defaultBackColor = "#888888"; foreach (var ct in type.GetCustomAttributes(true)) { if (ct != null && ct.GetType() == typeof(ExportableExcelHeaderAttribute)) { ExportableExcelHeaderAttribute exportableAttribute = (ct as ExportableExcelHeaderAttribute); rowStyle = new RowStyle(); if (!StringMethods.IsNullOrWhiteSpace(exportableAttribute.FontName)) rowStyle.FontName = exportableAttribute.FontName; else rowStyle.FontName = defaultFontName; if (!StringMethods.IsNullOrWhiteSpace(exportableAttribute.FontColor)) rowStyle.FontColor = exportableAttribute.FontColor; else rowStyle.FontColor = defaultFontColor; if ((exportableAttribute.FontSize) > 0) rowStyle.FontSize = exportableAttribute.FontSize; else rowStyle.FontSize = defaultFontSize; if (!StringMethods.IsNullOrWhiteSpace(exportableAttribute.BorderColor)) rowStyle.BorderColor = exportableAttribute.BorderColor; else rowStyle.BorderColor = defaultBorderColor; if (!StringMethods.IsNullOrWhiteSpace(exportableAttribute.BackColor)) rowStyle.BackColor = exportableAttribute.BackColor; else rowStyle.BackColor = defaultBackColor; return rowStyle; } } return new RowStyle(defaultFontColor, defaultFontName, defaultFontSize, defaultBorderColor, defaultBackColor); }