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