</telerik:RadScriptManager>
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="ddlAssetType" EventName="SelectedIndexChanged" >
<telerik:AjaxSetting AjaxControlID="ddlChart" >
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="rcStats" />
</UpdatedControls>
</telerik:AjaxSetting>
<telerik:AjaxSetting AjaxControlID="ddlRange" >
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="rcStats" />
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
rcStats.DataSource = list
rcStats.DataBind()
protected
void CfnReportGrid_ExcelMLExportRowCreated(object sender, Telerik.Web.UI.GridExcelBuilder.GridExportExcelMLRowCreatedArgs e)
{
if (e.RowType == Telerik.Web.UI.GridExcelBuilder.GridExportExcelMLRowType.HeaderRow)
{
Telerik.Web.UI.GridExcelBuilder.
RowElement row = new Telerik.Web.UI.GridExcelBuilder.RowElement();
Telerik.Web.UI.GridExcelBuilder.
CellElement cell = new Telerik.Web.UI.GridExcelBuilder.CellElement();
cell.Data.DataItem =
"NYC DEPARTMENT OF EDUCATION";
cell.StyleValue =
"MyHeaderStyle";
cell.MergeAcross = e.Row.Cells.Count - 1;
row.Cells.Add(cell);
e.Worksheet.Table.Rows.Insert(0, row);
}
And then in another event I do styling this header:
protected
void CfnReportGrid_ExcelMLExportStylesCreated(object sender, Telerik.Web.UI.GridExcelBuilder.GridExportExcelMLStyleCreatedArgs e)
{
Telerik.Web.UI.GridExcelBuilder.StyleElement myStyleH = new lerik.Web.UI.GridExcelBuilder.StyleElement"MyHeaderStyle");
myStyleH.FontStyle.Size = 25;
myStyleH.FontStyle.Bold =
true;
System.Drawing.
Color col = System.Drawing.ColorTranslator.FromHtml("#2C78FF");
myStyleH.FontStyle.Color = col;
myStyleH.AlignmentElement.HorizontalAlignment = Telerik.Web.UI.GridExcelBuilder.HorizontalAlignmentType.Center;
e.Styles.Add(myStyleH);
}
My question is:I need colored each letter of "NYC" in different color:
letter "N" in green color
letter "Y" in orange color
letter "C" in blue color
And it should by on the same line.
Thanks so much for your help.
<
telerik:radGrid ID = "grid_Report" runat ="server" OnPreRender="grid_Report_PreRender" OnDataBound="grid_Report_DataBound"
AllowFilteringByColumn="false" AllowSorting="false" AutoGenerateColumns="False" ShowHeader="false" EnableViewState="true"
CellSpacing="0" GridLines="None" Width = "1000px"
ShowGroupPanel="True" PageSize="20">
<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>
<MasterTableView DataKeyNames="ID" >
<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>
<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
<Columns>
<telerik:GridBoundColumn UniqueName="Center" DataType="System.String" DataField="Center" HeaderText="Center" SortExpression="Center"
ItemStyle-HorizontalAlign="Left" HeaderStyle-Width="200px" HeaderStyle-HorizontalAlign="Left" ItemStyle-Wrap="false" HeaderStyle-Font-Bold="true" ItemStyle-Width="200px" ReadOnly="true" >
</telerik:GridBoundColumn>
<telerik:GridTemplateColumn >
<ItemTemplate>
<telerik:RadGrid ID = "grid_SubReport" runat ="server" OnNeedDataSource='<%# DataBinder.Eval(Container.DataItem, "Center") %>'
AllowFilteringByColumn="false" AllowSorting="false" ShowHeader="true"
CellSpacing="0" GridLines="None" Width = "1000px"
ShowGroupPanel="True" PageSize="20">
<MasterTableView DataKeyNames="Center" >
<Columns>
<telerik:GridTemplateColumn HeaderText = "Student Coordinator" UniqueName = "Name" HeaderStyle-Width = "200px" HeaderStyle-Font-Bold="true" ItemStyle-Width = "200px" FilterControlWidth = "150px">
<ItemTemplate>
<asp:TextBox ID="txt_Name" runat="Server" Text='<%# Eval("Name") %>' ></asp:TextBox>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText = "Student Contact" UniqueName = "Contact" HeaderStyle-Width = "200px" HeaderStyle-Font-Bold="true" ItemStyle-Width = "200px" FilterControlWidth = "150px">
<ItemTemplate>
<asp:TextBox ID="txt_Contact" runat="Server" Text='<%# Eval("Contact") %>' ></asp:TextBox>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn FilterControlAltText="Filter TemplateColumn column" UniqueName="btn_Assign" AllowFiltering="false" ItemStyle-HorizontalAlign ="Center">
<ItemTemplate>
<telerik:RadButton ID="btn_Assign" runat="server" Text="Assign"></telerik:RadButton>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText = "Assigned Date" UniqueName = "Date" HeaderStyle-Width = "200px" HeaderStyle-Font-Bold="true" ItemStyle-Width = "200px" FilterControlWidth = "150px">
<ItemTemplate>
<asp:Label ID="lbl_Date" runat="server" Text="as"></asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn FilterControlAltText="Filter TemplateColumn column" UniqueName="btn_add" AllowFiltering="false" ItemStyle-HorizontalAlign ="Center">
<ItemTemplate>
<telerik:RadButton ID="btn_Delet" runat="server" Text="Delete"></telerik:RadButton>
<telerik:RadButton ID="btn_Add" runat="server" Text="Add"></telerik:RadButton>
</ItemTemplate>
</telerik:GridTemplateColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
</ItemTemplate>
</telerik:GridTemplateColumn>
</Columns>
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</EditFormSettings>
</MasterTableView>
<ClientSettings EnableRowHoverStyle="true" AllowDragToGroup="false">
<Selecting AllowRowSelect="True" />
</ClientSettings>
<FilterMenu EnableImageSprites="False"></FilterMenu>
</telerik:radGrid>