C# (CSharp) Telerik.Web.UI.GridExcelBuilder.StyleElement Examples

Example #1

File: frm_downloadesi.aspx.cs Project: shivareddyanumula/Comesa

 /// <summary>
 /// this region will format the headers i.e. columns and there data
 /// </summary>
 /// <param name="source"></param>
 /// <param name="e"></param>
 protected void rg_ESIDownload_ExcelMLExportStylesCreated1(object source, Telerik.Web.UI.GridExcelBuilder.GridExportExcelMLStyleCreatedArgs e)
 {
     try
     {
         foreach (Telerik.Web.UI.GridExcelBuilder.StyleElement style in e.Styles)
         {
             if (style.Id == "headerStyle")
             {
                 style.FontStyle.Bold        = true;
                 style.FontStyle.Color       = System.Drawing.Color.CadetBlue;
                 style.InteriorStyle.Color   = System.Drawing.Color.Wheat;
                 style.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid;
             }
         }
         Telerik.Web.UI.GridExcelBuilder.StyleElement myStyle = new Telerik.Web.UI.GridExcelBuilder.StyleElement("MyCustomStyle");
         myStyle.FontStyle.Bold        = true;
         myStyle.FontStyle.Italic      = true;
         myStyle.InteriorStyle.Color   = System.Drawing.Color.LightGray;
         myStyle.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid;
         e.Styles.Add(myStyle);
     }
     catch (Exception ex)
     {
         SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_downloadesi", ex.StackTrace, DateTime.Now);
         Response.Redirect("~/Frm_ErrorPage.aspx");
     }
 }

Example #2

File: member-training-certs.aspx.cs Project: publichealthcloud/absenteesurveillance

    protected void RadGrid1_ExcelMLExportStylesCreated(object source, Telerik.Web.UI.GridExcelBuilder.GridExportExcelMLStyleCreatedArgs e)
    {
        foreach (Telerik.Web.UI.GridExcelBuilder.StyleElement style in e.Styles)
        {
            if (style.Id == "headerStyle")
            {
                style.FontStyle.Bold = true;
                style.FontStyle.Color = System.Drawing.Color.Gainsboro;
                style.InteriorStyle.Color = System.Drawing.Color.Wheat;
                style.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid;
            }
            else if (style.Id == "itemStyle")
            {
                style.InteriorStyle.Color = System.Drawing.Color.WhiteSmoke;
                style.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid;
            }
            else if (style.Id == "alternatingItemStyle")
            {
                style.InteriorStyle.Color = System.Drawing.Color.LightGray;
                style.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid;
            }
        }

        Telerik.Web.UI.GridExcelBuilder.StyleElement myStyle = new Telerik.Web.UI.GridExcelBuilder.StyleElement("MyCustomStyle");
        myStyle.FontStyle.Bold = true;
        myStyle.FontStyle.Italic = true;
        myStyle.InteriorStyle.Color = System.Drawing.Color.Gray;
        myStyle.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid;
        e.Styles.Add(myStyle);
    }