or

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="RadGrid.aspx.cs" Inherits="TestTelerikAspxGrid.Web.RadGrid" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"><html><head runat="server"> <title>RadGrid</title> <script language="javascript" type="text/javascript"> function RequestStart(sender, args) { if (args.get_eventTarget().indexOf("ExportToExcelButton") >= 0) { args.set_enableAjax(false); } } </script></head><body> <form id="form1" runat="server"> <telerik:RadScriptManager runat="server" ID="RadScriptManager1" /> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="RadGridFootballPlayers"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadAjaxPanel"></telerik:AjaxUpdatedControl> <telerik:AjaxUpdatedControl ControlID="RadGridFootballPlayers"></telerik:AjaxUpdatedControl> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Default"> </telerik:RadAjaxLoadingPanel> <telerik:RadAjaxPanel runat="server" ID="RadAjaxPanel" LoadingPanelID="RadAjaxLoadingPanel1" ClientEvents-OnRequestStart="RequestStart"> <br/> <input id="Button1" type="button" value="button" runat="server" /> <br/> <telerik:RadGrid ID="RadGridFootballPlayers" runat="server" Skin="WebBlue" PageSize="10" GridLines="None" AutoGenerateColumns="false" AllowSorting="True" AllowPaging="True" AllowMultiRowSelection="True" AllowFilteringByColumn="True" EnableLinqExpressions="false"> <ExportSettings ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true"> <Excel Format="ExcelML"></Excel> </ExportSettings> <groupingsettings casesensitive="false"></groupingsettings> <MasterTableView TableLayout="Fixed" CommandItemDisplay="Top" UseAllDataFields="true"> <CommandItemSettings ShowExportToExcelButton="true" ShowAddNewRecordButton="false"></CommandItemSettings> <Columns> <telerik:GridBoundColumn UniqueName="Id" DataField="Id" HeaderText="Id" SortExpression="Id" AutoPostBackOnFilter="true" ShowFilterIcon="false" CurrentFilterFunction="Contains"> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="Name" DataField="Name" HeaderText="Name" SortExpression="Name" AutoPostBackOnFilter="true" ShowFilterIcon="false" CurrentFilterFunction="Contains"> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="Surname" DataField="Surname" HeaderText="Surname" SortExpression="Surname" AutoPostBackOnFilter="true" ShowFilterIcon="false" CurrentFilterFunction="Contains"> </telerik:GridBoundColumn> <telerik:GridDateTimeColumn UniqueName="FirstSubscriptionDate" DataField="BirthDate" DataType="System.DateTime" DataFormatString="{0:dd/MM/yyyy HH:mm:ss}" HeaderText="First Sub Date" SortExpression="FirstSubscriptionDate" HeaderStyle-Width="150" AutoPostBackOnFilter="true" EnableTimeIndependentFiltering="true" AllowFiltering="false"> </telerik:GridDateTimeColumn> <telerik:GridBoundColumn UniqueName="FootballClub" DataField="FootballClub" HeaderText="FootballClub" SortExpression="FootballClub" AutoPostBackOnFilter="true" ShowFilterIcon="false" CurrentFilterFunction="Contains"> </telerik:GridBoundColumn> <telerik:GridBoundColumn UniqueName="Role" DataField="Role" HeaderText="Role" SortExpression="Role" AutoPostBackOnFilter="true" ShowFilterIcon="false" CurrentFilterFunction="Contains"> </telerik:GridBoundColumn> </Columns> </MasterTableView> <ClientSettings AllowDragToGroup="True"> <Selecting AllowRowSelect="True" /> </ClientSettings> <PagerStyle Mode="NextPrevAndNumeric"></PagerStyle> </telerik:RadGrid> </telerik:RadAjaxPanel> </form></body></html>using System;using System.Collections.Generic;using System.Web.UI.WebControls;using Telerik.Web.UI;using Telerik.Web.UI.GridExcelBuilder;using TestTelerikAspxGrid.Web.Bm;using TestTelerikAspxGrid.Web.Entities;namespace TestTelerikAspxGrid.Web{ public partial class RadGrid : System.Web.UI.Page { private bool _isConfigured; protected void Page_Load(object sender, EventArgs e) { Button1.ServerClick += RadButton1Click; RadGridFootballPlayers.NeedDataSource += RadGridPendingFootballPlayersNeedDataSource; RadGridFootballPlayers.PageSizeChanged += RadGridPendingFootballPlayersPageSizeChanged; RadGridFootballPlayers.PageIndexChanged += RadGridPendingFootballPlayersPageIndexChanged; RadGridFootballPlayers.SortCommand += RadGridPendingFootballPlayersSortCommand; RadGridFootballPlayers.ExcelMLExportRowCreated += RadGridExcelMlExportRowCreated; RadGridFootballPlayers.ExcelMLExportStylesCreated += RadGridExcelMlExportStylesCreated; if (IsPostBack) return; Session["GridData"] = new List<EntityFootballPlayer>(); } protected void RadButton1Click(object sender, EventArgs e) { LoadData(); } private void LoadData() { var footballPlayers = new ManagerRadGrid().GetFootballPlayers(); Session["GridData"] = footballPlayers; RadGridFootballPlayers.DataSource = footballPlayers; RadGridFootballPlayers.DataBind(); } private void LoadDataEventRadGridPendingFootballPlayers() { RadGridFootballPlayers.DataSource = Session["GridData"]; RadGridFootballPlayers.DataBind(); } protected void RadGridPendingFootballPlayersNeedDataSource(object sender, GridNeedDataSourceEventArgs e) { RadGridFootballPlayers.MasterTableView.DataSource = Session["GridData"]; } protected void RadGridPendingFootballPlayersPageSizeChanged(object source, GridPageSizeChangedEventArgs e) { LoadDataEventRadGridPendingFootballPlayers(); } protected void RadGridPendingFootballPlayersPageIndexChanged(object source, GridPageChangedEventArgs e) { LoadDataEventRadGridPendingFootballPlayers(); } protected void RadGridPendingFootballPlayersSortCommand(object source, GridSortCommandEventArgs e) { LoadDataEventRadGridPendingFootballPlayers(); } #region Export protected void RadGridExcelMlExportRowCreated(object sender, GridExportExcelMLRowCreatedArgs e) { if (e.RowType == GridExportExcelMLRowType.DataRow) { if (e.Row.Cells.Count == 0) return; if (!_isConfigured) { //Set Worksheet name e.Worksheet.Name = "Order Details Extended"; //Set Column widths foreach (ColumnElement column in e.Worksheet.Table.Columns) { if (e.Worksheet.Table.Columns.IndexOf(column) == 2) column.Width = Unit.Point(180); //set width 180 to ProductName column else column.Width = Unit.Point(80); //set width 80 to the rest of the columns } //Set Page options var pageSetup = e.Worksheet.WorksheetOptions.PageSetup; pageSetup.PageLayoutElement.IsCenteredVertical = true; pageSetup.PageLayoutElement.IsCenteredHorizontal = true; pageSetup.PageMarginsElement.Left = 0.5; pageSetup.PageMarginsElement.Top = 0.5; pageSetup.PageMarginsElement.Right = 0.5; pageSetup.PageMarginsElement.Bottom = 0.5; pageSetup.PageLayoutElement.PageOrientation = PageOrientationType.Landscape; //Freeze panes e.Worksheet.WorksheetOptions.AllowFreezePanes = true; e.Worksheet.WorksheetOptions.LeftColumnRightPaneNumber = 1; e.Worksheet.WorksheetOptions.TopRowBottomPaneNumber = 1; e.Worksheet.WorksheetOptions.SplitHorizontalOffset = 1; e.Worksheet.WorksheetOptions.SplitVerticalOffest = 1; e.Worksheet.WorksheetOptions.ActivePane = 2; _isConfigured = true; } } } protected void RadGridExcelMlExportStylesCreated(object sender, GridExportExcelMLStyleCreatedArgs e) { //Add currency and percent styles var priceStyle = new StyleElement("priceItemStyle"); priceStyle.NumberFormat.FormatType = NumberFormatType.Currency; priceStyle.FontStyle.Color = System.Drawing.Color.Red; e.Styles.Add(priceStyle); var alternatingPriceStyle = new StyleElement("alternatingPriceItemStyle"); alternatingPriceStyle.NumberFormat.FormatType = NumberFormatType.Currency; alternatingPriceStyle.FontStyle.Color = System.Drawing.Color.Red; e.Styles.Add(alternatingPriceStyle); var percentStyle = new StyleElement("percentItemStyle"); percentStyle.NumberFormat.FormatType = NumberFormatType.Percent; percentStyle.FontStyle.Italic = true; e.Styles.Add(percentStyle); var alternatingPercentStyle = new StyleElement("alternatingPercentItemStyle"); alternatingPercentStyle.NumberFormat.FormatType = NumberFormatType.Percent; alternatingPercentStyle.FontStyle.Italic = true; e.Styles.Add(alternatingPercentStyle); //Apply background colors foreach (StyleElement style in e.Styles) { if (style.Id == "headerStyle") { style.InteriorStyle.Pattern = InteriorPatternType.Solid; style.InteriorStyle.Color = System.Drawing.Color.Gray; } 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; } } } #endregion }}

<telerik:RadSplitter ID="uxRadSplitter" runat="server" Width="788" Height="543" Orientation="Horizontal" VisibleDuringInit="false" BorderSize="0" > <telerik:RadPane ID="uxRadPaneTop" runat="server" > Sample </telerik:RadPane> <telerik:RadPane ID="uxRadPaneBottom" runat="server" Height="25px" Scrolling="none" CssClass="SlidingPaneFilterTitle" > <telerik:RadSlidingZone ID="uxRadSlidingZone" runat="server" Height="25px" SlideDirection="Top"> <telerik:RadSlidingPane ID="uxRadSlidingPaneFilter" Title="Filter Options" runat="server" Height="175px" EnableDock="false" EnableResize="false" IconUrl="/Images/Icons/16/search.png"> <telerik:RadToolBar ID="uxRadToolBar" runat="server" OnClientButtonClicking="clientButtonClicking" style="margin-top:5px;"> <items> <telerik:RadToolBarButton Value="Filter" Text="Apply" ImageUrl="/Images/Icons/16/search.png" CausesValidation="False" /> </items> </telerik:RadToolBar> </telerik:RadSlidingPane> </telerik:RadSlidingZone> </telerik:RadPane> </telerik:RadSplitter>