protected void RadGrid1_ExcelMLExportStyles(object source, 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;
}
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.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_esiimport", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
//Add styles to the exported file from telerik in type ExcelIM
protected void CustomersGRD_OnExcelMLExportStylesCreated(object sender, GridExportExcelMLStyleCreatedArgs e)
{
// To set the Excel cell borders style
BorderStylesCollection borders = new BorderStylesCollection();
BorderStyles borderStyle = null;
for (int i = 1; i <= 4; i++)
{
borderStyle = new BorderStyles();
borderStyle.PositionType = (PositionType)i;
borderStyle.Color = System.Drawing.Color.Black;
borderStyle.LineStyle = LineStyle.Continuous;
borderStyle.Weight = 1.0;
borders.Add(borderStyle);
}
// styles have to set for export excel
foreach (StyleElement style in e.Styles)
{
//For Header style - background color
if (style.Id == "headerStyle")
{
style.InteriorStyle.Pattern = InteriorPatternType.Solid;
style.InteriorStyle.Color = System.Drawing.Color.Gray;
}
//For alternate row style - background color
if (style.Id == "alternatingItemStyle" || style.Id == "alternatingPriceItemStyle" || style.Id == "alternatingPercentItemStyle" || style.Id == "alternatingDateItemStyle")
{
style.InteriorStyle.Pattern = InteriorPatternType.Solid;
style.InteriorStyle.Color = System.Drawing.Color.LightGray;
}
if
(
style.Id.Contains("itemStyle") || style.Id == "priceItemStyle" || style.Id == "percentItemStyle" || style.Id == "dateItemStyle")
{
style.InteriorStyle.Pattern = InteriorPatternType.Solid;
style.InteriorStyle.Color = System.Drawing.Color.White;
}
// for each cell border styles
foreach (BorderStyles border in borders)
{
style.Borders.Add(border);
}
// Each cell text wrapping
style.AlignmentElement.Attributes.Add("ss:WrapText", "1");
}
}
protected void OnGridInvoiceExcelMLExportStylesCreated(object source,
GridExportExcelMLStyleCreatedArgs e)
{
foreach (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 = InteriorPatternType.Solid;
}
else if (style.Id == "itemStyle")
{
style.InteriorStyle.Color = System.Drawing.Color.WhiteSmoke;
style.InteriorStyle.Pattern = InteriorPatternType.Solid;
}
else if (style.Id == "alternatingItemStyle")
{
style.InteriorStyle.Color = System.Drawing.Color.LightGray;
style.InteriorStyle.Pattern = InteriorPatternType.Solid;
}
}
StyleElement myStyle = new StyleElement("MyCustomStyle");
myStyle.FontStyle.Bold = true;
myStyle.FontStyle.Italic = true;
myStyle.InteriorStyle.Color = System.Drawing.Color.Gray;
myStyle.InteriorStyle.Pattern = InteriorPatternType.Solid;
e.Styles.Add(myStyle);
}
