public ExportCacheCellStyle GetBandHeaderStyle() { ExportCacheCellStyle cellStyle = DefaultCellStyle; cellStyle.BkColor = Color.FromArgb(236, 233, 216); cellStyle.TextAlignment = StringAlignment.Center; ExportCacheCellBorderStyle borderStyle = new ExportCacheCellBorderStyle(); borderStyle.Color_ = Color.FromArgb(212, 208, 200); borderStyle.Width = 3; cellStyle.TopBorder = cellStyle.BottomBorder = cellStyle.LeftBorder = cellStyle.RightBorder = borderStyle; return(cellStyle); }
public ExportCacheCellStyle GetColumnHeaderStyle() { ExportCacheCellStyle cellStyle = DefaultCellStyle; cellStyle.BkColor = Color.FromArgb(245, 240, 220); cellStyle.TextAlignment = StringAlignment.Near; ExportCacheCellBorderStyle borderStyle = new ExportCacheCellBorderStyle(); borderStyle.Color_ = Color.FromArgb(220, 210, 205); borderStyle.Width = 2; cellStyle.BottomBorder = cellStyle.LeftBorder = cellStyle.RightBorder = borderStyle; return(cellStyle); }
public XtraGridExcelExporterBase(string fileName, GridView pGridView) { _xlsProvider = new DevExpress.XtraExport.ExportXlsProvider(fileName); _gridView = pGridView; ExportCacheCellStyle cellStyle = _xlsProvider.GetDefaultStyle(); cellStyle.BkColor = Color.White; cellStyle.TextAlignment = StringAlignment.Near; ExportCacheCellBorderStyle borderStyle = new ExportCacheCellBorderStyle(); borderStyle.Color_ = Color.White; borderStyle.Width = 1; cellStyle.TopBorder = cellStyle.BottomBorder = cellStyle.LeftBorder = cellStyle.RightBorder = borderStyle; _xlsProvider.SetDefaultStyle(cellStyle); }
public static ExportCacheCellStyle ConvertAppearanceToCellStyle(AppearanceObject ap) { ExportCacheCellStyle cellStyle = new ExportCacheCellStyle(); cellStyle.BkColor = ap.BackColor2; cellStyle.FgColor = ap.ForeColor; switch (ap.TextOptions.HAlignment) { case HorzAlignment.Far: cellStyle.TextAlignment = StringAlignment.Far; break; case HorzAlignment.Near: cellStyle.TextAlignment = StringAlignment.Near; break; default: cellStyle.TextAlignment = StringAlignment.Center; break; } ExportCacheCellBorderStyle borderStyle = new ExportCacheCellBorderStyle(); borderStyle.Color_ = Color.FromArgb(220, 210, 205); borderStyle.Width = 1; cellStyle.TopBorder = cellStyle.BottomBorder = cellStyle.LeftBorder = cellStyle.RightBorder = borderStyle; cellStyle.TextFont = ap.Font; return(cellStyle); }