protected virtual void ApplyAlignment(ExcelStyle sourceStyle, OfficeOpenXml.Style.ExcelStyle destinationStyle) { if (sourceStyle.HorizontalAlignment.HasValue) { destinationStyle.HorizontalAlignment = (ExcelHorizontalAlignment)sourceStyle.HorizontalAlignment.Value; } if (sourceStyle.VerticalAlignment.HasValue) { destinationStyle.VerticalAlignment = (ExcelVerticalAlignment)sourceStyle.VerticalAlignment.Value; } }
protected virtual void ApplyBorder(ExcelStyle sourceStyle, OfficeOpenXml.Style.ExcelStyle destinationStyle) { if (sourceStyle.Border == null) { return; } ApplyBorderItem(destinationStyle.Border.Bottom, sourceStyle.Border.Bottom); ApplyBorderItem(destinationStyle.Border.Top, sourceStyle.Border.Top); ApplyBorderItem(destinationStyle.Border.Right, sourceStyle.Border.Right); ApplyBorderItem(destinationStyle.Border.Left, sourceStyle.Border.Left); }
public virtual void ApplyStyle(ExcelStyle sourceStyle, OfficeOpenXml.Style.ExcelStyle destinationStyle) { if (sourceStyle == null) { return; } destinationStyle.WrapText = sourceStyle.WrapText; if (!string.IsNullOrWhiteSpace(sourceStyle.NumberFormat)) { destinationStyle.Numberformat.Format = sourceStyle.NumberFormat; } ApplyBorder(sourceStyle, destinationStyle); ApplyFill(sourceStyle, destinationStyle); ApplyFont(sourceStyle, destinationStyle); ApplyAlignment(sourceStyle, destinationStyle); }
protected virtual void ApplyFill(ExcelStyle sourceStyle, OfficeOpenXml.Style.ExcelStyle destinationStyle) { if (sourceStyle.Fill == null) { return; } if (sourceStyle.Fill.PatternType.HasValue) { destinationStyle.Fill.PatternType = (ExcelFillStyle)sourceStyle.Fill.PatternType; } if (sourceStyle.Fill.BackgroundColor != null) { destinationStyle.Fill.BackgroundColor.SetColor(sourceStyle.Fill.BackgroundColor.Value); } if (sourceStyle.Fill.PatternColor != null) { destinationStyle.Fill.PatternColor.SetColor(sourceStyle.Fill.PatternColor.Value); } }
protected virtual void ApplyFont(ExcelStyle sourceStyle, OfficeOpenXml.Style.ExcelStyle destinationStyle) { if (sourceStyle.Font == null) { return; } if (sourceStyle.Font.Font != null) { destinationStyle.Font.SetFromFont(sourceStyle.Font.Font); } if (sourceStyle.Font.FontColor.HasValue) { destinationStyle.Font.Color.SetColor(sourceStyle.Font.FontColor.Value); } if (sourceStyle.Font.VerticalAlignmentFont.HasValue) { destinationStyle.Font.VerticalAlign = (ExcelVerticalAlignmentFont)sourceStyle.Font.VerticalAlignmentFont.Value; } }