void exporter_ExcelTableCreated(object sender, Telerik.WinControls.UI.Export.ExcelML.ExcelTableCreatedEventArgs e)
{
string headerText = "Custom added header text.";
SingleStyleElement style = ((ExportToExcelML)sender).AddCustomExcelRow(e.ExcelTableElement, 50, headerText);
style.FontStyle.Bold = true;
style.FontStyle.Size = 18;
style.FontStyle.Color = Color.White;
style.InteriorStyle.Color = Color.Red;
style.InteriorStyle.Pattern = InteriorPatternType.Solid;
style.AlignmentElement.HorizontalAlignment = HorizontalAlignmentType.Center;
style.AlignmentElement.VerticalAlignment = VerticalAlignmentType.Center;
}
/// <summary>
/// using ExcelTableCreated event for adding custom header row
/// </summary>
void exporter_ExcelTableCreated(object sender, ExcelTableCreatedEventArgs e)
{
if (e.SheetIndex == 0) //add header row only for the first excel sheet
{
SingleStyleElement style = ((ExportToExcelML)sender).AddCustomExcelRow(e.ExcelTableElement, 48, "TABLE's TITLE");
style.AlignmentElement.HorizontalAlignment = HorizontalAlignmentType.Center;
style.AlignmentElement.VerticalAlignment = VerticalAlignmentType.Center;
style.InteriorStyle.Pattern = InteriorPatternType.Solid;
style.InteriorStyle.Color = Color.Red;
style.FontStyle.Color = Color.White;
style.FontStyle.Bold = true;
style.FontStyle.Size = 26;
}
}
void export_ExcelTableCreated(object sender, Telerik.WinControls.UI.Export.ExcelML.ExcelTableCreatedEventArgs e)
{
if (this.Heading.ToStr().Trim().Length > 0)
{
// string headerText = "Data Range : " + string.Format("{0:dd-MMM-yy}", dtpFromDate2.Value) + " to " + string.Format("{0:dd-MMM-yy}", dtpToDate2.Value);
SingleStyleElement style = ((ExportToExcelML)sender).AddCustomExcelRow(e.ExcelTableElement, 30, this.Heading);
style.FontStyle.Bold = true;
if (ApplyCustomCellFormatting)
{
this.TitleFontSize = 12;
}
style.FontStyle.Size = this.TitleFontSize; //18;
style.FontStyle.Color = this.TitleForeColor; //Color.White;
style.InteriorStyle.Color = this.TitleBackColor; //Color.Red;
style.InteriorStyle.Pattern = InteriorPatternType.Solid;
style.AlignmentElement.HorizontalAlignment = HorizontalAlignmentType.Center;
style.AlignmentElement.VerticalAlignment = VerticalAlignmentType.Center;
}
}
