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);
}
