or
<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"> <script type="text/javascript"> function mngRequestStarted(ajaxManager, eventArgs) { if ((eventArgs.EventTarget.indexOf("GridExportToCSV") != -1) || (eventArgs.EventTarget.indexOf("GridExportToXLS") != -1) { eventArgs.EnableAjax = false; } } </script> </telerik:RadCodeBlock> <telerik:RadScriptManager ID="tsmGeneric" runat="server" EnableScriptGlobalization="true" EnableScriptLocalization="true"> </telerik:RadScriptManager> <telerik:RadAjaxManager ID="mainAjaxManager" runat="server" ClientEvents-OnRequestStart="mngRequestStarted"> <ClientEvents OnRequestStart="mngRequestStarted" /> </telerik:RadAjaxManager> . . . <asp:ContentPlaceHolder ID="cphMainContent" runat="server"> </asp:ContentPlaceHolder><asp:Content ID="cntMain" ContentPlaceHolderID="cphMainContent" runat="server"> <telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxy1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="gvwOperations"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="gvwOperations" LoadingPanelID="rlpLoading"/> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="dropPeriods" > <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="gvwOperations" LoadingPanelID="rlpLoading"/> <telerik:AjaxUpdatedControl ControlID="pnlDateRange"/> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="dropUsers" > <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="gvwOperations" LoadingPanelID="rlpLoading"/> </UpdatedControls> </telerik:AjaxSetting> <telerik:AjaxSetting AjaxControlID="btnGO"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="gvwOperations" LoadingPanelID="rlpLoading"/> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManagerProxy> <telerik:RadAjaxLoadingPanel ID="rlpLoading" runat="server" Skin="Windows7" /> <telerik:RadGrid ID="gvwOperations" runat="server" AllowPaging="True" AutoGenerateColumns="False" GridLines="None" Skin="Windows7" AllowSorting="True" OnNeedDataSource="gvwOperations_NeedDataSource" OnItemCommand="gvwOperations_ItemCommand" onitemcreated="gvwOperations_ItemCreated" onitemdatabound="gvwOperations_ItemDataBound"> <ExportSettings ExportOnlyData="True" IgnorePaging="True" OpenInNewWindow="True"> <Pdf PageWidth="297mm" PageHeight="210mm" /> </ExportSettings> <ClientSettings EnableRowHoverStyle="true" ReorderColumnsOnClient="false" AllowKeyboardNavigation="true" > <Resizing AllowColumnResize="true" EnableRealTimeResize="true" /> </ClientSettings> <MasterTableView CommandItemDisplay="Top" TableLayout="Fixed" PageSize="6" BorderStyle="None" EnableHeaderContextMenu="true" EnableHeaderContextFilterMenu="true" IsFilterItemExpanded="false" AllowFilteringByColumn="True"> <CommandItemTemplate> <asp:CheckBox ID="chkAllowGroup" runat="server" Text="Allow Group Columns" TextAlign="Right" Checked="false" OnCheckedChanged="chkAllowGroup_CheckedChanged"/> <asp:Button ID="GridExportToCSV" runat="server" Text="CSV" OnClick="btnDownloadCSV_Click"/> <asp:Button ID="GridExportToXLS" runat="server" Text="Excel" OnClick="btnDownloadXLS_Click"/> </CommandItemTemplate> <CommandItemSettings /> <Columns> <telerik:GridBoundColumn DataField="ProcessDateTime" HeaderStyle-Width="150px" DataType="System.DateTime" HeaderText="ProcessDateTime" SortExpression="ProcessDateTime" UniqueName="ProcessDateTime" meta:resourcekey="GridBoundColumnResource1"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="OperationID" HeaderStyle-Width="120px" HeaderText="OperationID" SortExpression="OperationID" UniqueName="OperationID" meta:resourcekey="GridBoundColumnResource2"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" /> <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="TransactionID" HeaderText="TransactionID" DataType="System.Int32" SortExpression="TransactionID" UniqueName="TransactionID" meta:resourcekey="GridBoundColumnResource3"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" /> <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="MerchantSalesID" HeaderText="MerchantSalesID" SortExpression="MerchantSalesID" UniqueName="MerchantSalesID" meta:resourcekey="GridBoundColumnResource4"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" /> <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Currency" HeaderText="Currency" SortExpression="Currency" UniqueName="Currency" meta:resourcekey="GridBoundColumnResource5"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" /> <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Amount" DataType="System.Decimal" DataFormatString="{0:0.00}" HeaderText="Amount" SortExpression="Amount" UniqueName="Amount" meta:resourcekey="GridBoundColumnResource6"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" /> <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ToCurrency" HeaderText="ToCurrency" SortExpression="ToCurrency" UniqueName="ToCurrency" meta:resourcekey="GridBoundColumnResource7"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" /> <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ToAmount" DataType="System.Decimal" DataFormatString="{0:0.00}" HeaderText="ToAmount" SortExpression="ToAmount" UniqueName="ToAmount" meta:resourcekey="GridBoundColumnResource8"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" /> <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" /> </telerik:GridBoundColumn> <telerik:GridTemplateColumn HeaderText="Estado" HeaderStyle-Width="55px" UniqueName="State" meta:resourcekey="GridTemplateColumnResource1"> <ItemTemplate> <asp:Image ID="imgStatus" runat="server" BorderWidth="0px" ImageUrl='<%# String.Format("~/Images/{0}.png", Eval("LastStatus")) %>' ToolTip='<%# GetLocalResourceObject(String.Format("tooltip{0}Transaction", Eval("LastStatus"))).ToString() %>' AlternateText='<%# GetLocalResourceObject(String.Format("alternateTxt{0}Transaction", Eval("LastStatus"))).ToString() %>' /> </ItemTemplate> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" /> <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" /> </telerik:GridTemplateColumn> <telerik:GridBoundColumn DataField="UserCompleteName" HeaderText="UserCompleteName" SortExpression="UserCompleteName" UniqueName="UserCompleteName" meta:resourcekey="GridBoundColumnResource9"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CustomerID" HeaderText="CustomerID" Visible="false" SortExpression="CustomerID" UniqueName="CustomerID" meta:resourcekey="GridBoundColumnResource10"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CustomerName" HeaderText="CustomerName" Visible="false" SortExpression="CustomerName" UniqueName="CustomerName" meta:resourcekey="GridBoundColumnResource11"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CustomerEmail" HeaderText="CustomerEmail" Visible="false" SortExpression="CustomerEmail" UniqueName="CustomerEmail" meta:resourcekey="GridBoundColumnResource12"> </telerik:GridBoundColumn> </Columns> </MasterTableView> <PagerStyle Mode="NextPrevAndNumeric" /> </telerik:RadGrid>Hi,
We are using 2010 Q1 SP1.
We have enebled excel export on a dynamically created grid (few columns are GridTemplateColumn and others are GridBoundColumn) and added programmatically on runtime.
If we make ExportOnlyData="true" and Format="Html" or ExcelML then it do not exports GridTemplateColumn columns.
If we make ExportOnlyData="false" and Format="Html" then it exports all data in all columns but it makes Columns headers as Links in exported file.
Is there any way to make grid to export data with ExportOnlyData="true" and Format="Html" or to remove link tag from the exported excel.
Thanks
GridDropDownListColumnEditor category = (GridDropDownListColumnEditor)item.EditManager.GetColumnEditor("RiskCategory"); TableCell catcell = (TableCell)category.ComboBoxControl.Parent; CompareValidator comp = new CompareValidator(); comp.ID = "compID"; comp.ControlToValidate = category.ComboBoxControl.ID; comp.ValueToCompare = "Select a category"; comp.Operator = ValidationCompareOperator.NotEqual; comp.ErrorMessage = "Please select a valid category"; catcell.Controls.Add(comp);if (Session["FacilityID"] != null) { FacilityID = Utils.ToInteger(Session["FacilityID"].ToString()); if (Utils.ToInteger(radcmbFacility.SelectedValue.ToString()) != FacilityID) { radcmbFacility.SelectedValue = FacilityID.ToString(); } }