protected void RG_Usuarios_ExcelMLWorkBookCreated(object sender, Telerik.Web.UI.GridExcelBuilder.GridExcelMLWorkBookCreatedEventArgs e) { foreach (RowElement row in e.WorkBook.Worksheets[0].Table.Rows) { row.Cells[0].StyleValue = "Style1"; } StyleElement style = new StyleElement("Style1"); style.InteriorStyle.Pattern = InteriorPatternType.Solid; style.InteriorStyle.Color = System.Drawing.Color.LightGray; e.WorkBook.Styles.Add(style); }
protected void grdResult_ExcelMLWorkBookCreated(object sender, Telerik.Web.UI.GridExcelBuilder.GridExcelMLWorkBookCreatedEventArgs e) { int r = 0; foreach (RowElement row in e.WorkBook.Worksheets[0].Table.Rows) { for (int i = 0; i < row.Cells.Count; i++) { if (r != 0) { if (r % 2 == 0) { row.Cells[i].StyleValue = "Style1"; } else { row.Cells[i].StyleValue = "Style2"; } } else { row.Cells[i].StyleValue = "styleHeader"; } } r++; } StyleElement styleHeader = new StyleElement("styleHeader"); styleHeader.InteriorStyle.Pattern = InteriorPatternType.Solid; styleHeader.InteriorStyle.Color = System.Drawing.Color.White; styleHeader.FontStyle.FontName = "Tahoma"; styleHeader.FontStyle.Bold = true; styleHeader.AlignmentElement.HorizontalAlignment = HorizontalAlignmentType.Center; e.WorkBook.Styles.Add(styleHeader); StyleElement style = new StyleElement("Style1"); style.InteriorStyle.Pattern = InteriorPatternType.Solid; style.InteriorStyle.Color = System.Drawing.Color.FromArgb(162, 226, 255); style.FontStyle.FontName = "Tahoma"; style.AlignmentElement.HorizontalAlignment = HorizontalAlignmentType.Center; e.WorkBook.Styles.Add(style); StyleElement style2 = new StyleElement("Style2"); style2.AlignmentElement.HorizontalAlignment = HorizontalAlignmentType.Center; style2.InteriorStyle.Pattern = InteriorPatternType.Solid; style2.InteriorStyle.Color = System.Drawing.Color.FromArgb(217, 243, 255); style2.FontStyle.FontName = "Tahoma"; e.WorkBook.Styles.Add(style2); }
private void makeExcel(Telerik.Web.UI.GridExcelBuilder.GridExcelMLWorkBookCreatedEventArgs e) { int r = 0; foreach (Telerik.Web.UI.GridExcelBuilder.RowElement row in e.WorkBook.Worksheets[0].Table.Rows) { for (int i = 0; i < row.Cells.Count; i++) { if (r != 0) { if (r % 2 == 0) { row.Cells[i].StyleValue = "lightBlue"; } else { row.Cells[i].StyleValue = "blue"; } } else { row.Cells[i].StyleValue = "styleHeader"; } } r++; } Telerik.Web.UI.GridExcelBuilder.StyleElement styleHeader = new Telerik.Web.UI.GridExcelBuilder.StyleElement("styleHeader"); styleHeader.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid; styleHeader.InteriorStyle.Color = System.Drawing.Color.White; styleHeader.FontStyle.FontName = "Tahoma"; styleHeader.FontStyle.Bold = true; styleHeader.AlignmentElement.HorizontalAlignment = Telerik.Web.UI.GridExcelBuilder.HorizontalAlignmentType.Center; e.WorkBook.Styles.Add(styleHeader); Telerik.Web.UI.GridExcelBuilder.StyleElement style = new Telerik.Web.UI.GridExcelBuilder.StyleElement("lightBlue"); style.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid; style.InteriorStyle.Color = System.Drawing.Color.FromArgb(162, 226, 255); style.FontStyle.FontName = "Tahoma"; style.AlignmentElement.HorizontalAlignment = Telerik.Web.UI.GridExcelBuilder.HorizontalAlignmentType.Center; e.WorkBook.Styles.Add(style); Telerik.Web.UI.GridExcelBuilder.StyleElement style2 = new Telerik.Web.UI.GridExcelBuilder.StyleElement("blue"); style2.AlignmentElement.HorizontalAlignment = Telerik.Web.UI.GridExcelBuilder.HorizontalAlignmentType.Center; style2.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid; style2.InteriorStyle.Color = System.Drawing.Color.FromArgb(217, 243, 255); style2.FontStyle.FontName = "Tahoma"; e.WorkBook.Styles.Add(style2); }