Beispiel #1
0
 private static void ExportingHandler(object sender, TreeGridExcelExportingEventArgs e)
 {
     if (e.CellType == TreeGridCellType.HeaderCell)
     {
         e.Style.Font.Bold = true;
     }
     e.Style.BeginUpdate();
     e.Style.Borders[ExcelBordersIndex.EdgeLeft].LineStyle   = ExcelLineStyle.Thin;
     e.Style.Borders[ExcelBordersIndex.EdgeRight].LineStyle  = ExcelLineStyle.Thin;
     e.Style.Borders[ExcelBordersIndex.EdgeTop].LineStyle    = ExcelLineStyle.Thin;
     e.Style.Borders[ExcelBordersIndex.EdgeBottom].LineStyle = ExcelLineStyle.Thin;
     e.Style.EndUpdate();
     e.Handled = true;
 }
Beispiel #2
0
        private static void ExportingHandler(object sender, TreeGridExcelExportingEventArgs e)
        {
            if (e.CellType == TreeGridCellType.HeaderCell)
            {
                e.Style.ColorIndex    = ExcelKnownColors.Light_yellow;
                e.Style.Font.Color    = ExcelKnownColors.Dark_red;
                e.Style.Font.Bold     = true;
                e.Style.Font.Size     = 12;
                e.Style.Font.FontName = "Segoe UI";
                e.Handled             = true;
            }

            else if (e.CellType == TreeGridCellType.RecordCell)
            {
                e.Style.Font.Color = ExcelKnownColors.Dark_red;
                e.Handled          = true;
            }
        }