protected void FormatColumnHeader(DynamicExcelColumn column, Excel.Range headerColumnCell) { headerColumnCell.Interior.Color = column.HeaderBackgroundColor; headerColumnCell.Font.Color = column.HeaderFontColor; headerColumnCell.ColumnWidth = column.Width; headerColumnCell.Font.Size = column.FontSize; headerColumnCell.Borders.LineStyle = Excel.XlLineStyle.xlContinuous; headerColumnCell.Borders.Color = ColorTranslator.ToOle(Color.SlateGray); SetTextAlignment(column, headerColumnCell); }
private void SetTextAlignment(DynamicExcelColumn column, Excel.Range headerColumnCell) { var headerAlignment = column.Alignment.FirstOrDefault(); if (headerAlignment.Value) { headerColumnCell.EntireColumn.HorizontalAlignment = headerAlignment.Key; } else { headerColumnCell.HorizontalAlignment = headerAlignment.Key; } }