I have seen other postings about Ajax messing up controls that are exporting to excel but I am not sure what to do since the entire user control has been ajaxified.
I have a web page that has a user control:
<telerik:RadAjaxManagerProxy ID="ramPackingSlip" runat="server">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="ramPackingSlip">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="lblError" />
<telerik:AjaxUpdatedControl ControlID="lblPageHeading" />
<telerik:AjaxUpdatedControl ControlID="pnlButtons" /
<telerik:AjaxUpdatedControl ControlID="ucPackSlipItemPickListInfo" />
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManagerProxy>
In the user control there is a grid and a button that I am using to export the grid contents to Excel:
Button to Export To Excel:
<asp:ImageButton ID="btnExcel" runat="server" ImageUrl="~/Images/ExportToExcel_up.png"
onmouseover="this.src='../images/ExportToExcel_ovr.png'" onmouseout="this.src='../images/ExportToExcel_up.png'"
OnClick="ibExportToExcel_Click" AlternateText="Xlsx" />
Button code behind:
protected void ibExportToExcel_Click(object sender, EventArgs e)
{ string joinInfo = string.Empty;
string extraInfo = string.Empty;
rgToolSelection.Rebind();
rgToolSelection.ExportSettings.OpenInNewWindow = true;
rgToolSelection.ExportSettings.ExportOnlyData = true;
rgToolSelection.ExportSettings.FileName = "RadGridExport";
rgToolSelection.MasterTableView.ExportToExcel();
}
Grid on the user control:
<telerik:RadGrid ID="rgToolSelection"
runat="server"
AllowPaging="true"
PageSize="100000"
GridLines="None"
AllowSorting="True"
DataSourceID="odsToolSelected"
EnableEmbeddedSkins="false"
AllowMultiRowSelection="true"
AllowAutomaticUpdates="true"
OnItemCommand="rgToolSelection_ItemCommand"
OnItemDataBound="rgToolSelection_ItemDataBound">
<PagerStyle Mode="NextPrevNumericAndAdvanced" />
<HeaderStyle HorizontalAlign="Center" />
<ClientSettings>
</ClientSettings>
<MasterTableView ClientDataKeyNames="ToolID" DataKeyNames="ToolID" AutoGenerateColumns="false" AllowAutomaticDeletes="True" EditMode="InPlace">
<Columns>
<telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete"
FilterControlAltText="Filter DeleteColumn column" HeaderText="Deselect"
ImageUrl="~/Images/Trash.gif" Text="Delete"
UniqueName="DeleteColumn" Resizable="false" ConfirmText="Remove Record?">
<HeaderStyle CssClass="rgHeader ButtonColumnHeader"></HeaderStyle>
<ItemStyle CssClass="ButtonColumn" />
</telerik:GridButtonColumn>
<telerik:GridTemplateColumn UniqueName="SerialNumber" HeaderText="Serial Number"
SortExpression="Serial_Number" ItemStyle-Wrap="false">
<ItemTemplate>
<asp:Image ID="imgStatus" runat="server"
Visible="true" />
<%# Eval("SerialNumber", "{0}")%>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn UniqueName="ToolName" HeaderText="Tool Name" DataField="ToolName" AllowSorting="false" />
<telerik:GridBoundColumn UniqueName="ComponentName" HeaderText="Component Name" DataField="ComponentName" AllowSorting="false" />
<telerik:GridBoundColumn UniqueName="SystemStatus" HeaderText="System Status" DataField="Status" AllowSorting="false" />
<telerik:GridBoundColumn UniqueName="ToolSizeName" HeaderText="Size" DataField="ToolSizeNameWithMM" AllowSorting="false" />
<telerik:GridTemplateColumn UniqueName="TemplateMoreInfoColumn" HeaderText="">
<ItemStyle HorizontalAlign="Center" />
<ItemTemplate>
<asp:ImageButton ID="ibMoreToolInfo" runat="server" ImageUrl="~/Images/Info.gif" OnClientClick="return false" />
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn UniqueName="IntendedUse" HeaderText="Intended Use">
<ItemStyle HorizontalAlign="Center" />
<ItemTemplate>
<asp:RadioButtonList ID="rblIntendedUse" runat="server" RepeatDirection="Horizontal">
<asp:ListItem Text="Land" Value="L" />
<asp:ListItem Text="Offshore" Value="O" />
</asp:RadioButtonList>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn UniqueName="Leasing" HeaderText="Leasing">
<ItemStyle HorizontalAlign="Center" />
<ItemTemplate>
<asp:RadioButtonList ID="rblLeasing" RepeatDirection="Horizontal" runat="server">
<asp:ListItem Text="Monthly" Value="M" />
<asp:ListItem Text="Long Term" Value="L" />
<asp:ListItem Text="None" Value="*" Selected="True" />
</asp:RadioButtonList>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn UniqueName="Value" HeaderText="Value">
<ItemStyle HorizontalAlign="Center" />
<ItemTemplate>
<telerik:RadNumericTextBox ID="rntbItemValue" runat="server" Width="60px" NumberFormat-DecimalDigits="2"
EnableEmbeddedSkins="false" EnabledStyle-HorizontalAlign="Right">
</telerik:RadNumericTextBox>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn UniqueName="DontPrint" HeaderText="Don't Print">
<ItemStyle HorizontalAlign="Center" />
<ItemTemplate>
<asp:CheckBox ID="chkDontPrint" runat="server"></asp:CheckBox>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn UniqueName="IsDefaultConsignment" HeaderText="Consignment">
<ItemStyle HorizontalAlign="Center" />
<ItemTemplate>
<asp:CheckBox ID="chkIsDefaultConsignment" runat="server"></asp:CheckBox>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn UniqueName="CommunityValue" HeaderText="Community">
<ItemStyle HorizontalAlign="Center" />
<ItemTemplate>
<asp:RadioButtonList ID="rblCommunity" RepeatDirection="Horizontal" runat="server">
<asp:ListItem Text="FCG" Value="1" />
<asp:ListItem Text="IPR" Value="2" />
<asp:ListItem Text="EU" Value="3" />
<asp:ListItem Text="None" Value="*" Selected="True" />
</asp:RadioButtonList>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn UniqueName="HTS" HeaderText="HTS">
<ItemStyle HorizontalAlign="Center" />
<ItemTemplate>
<telerik:RadTextBox ID="rtbHTS" runat="server" EnableEmbeddedSkins="false" Columns="10">
</telerik:RadTextBox>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn UniqueName="FieldTicket" HeaderText="Field Ticket" ItemStyle-VerticalAlign="Top">
<ItemStyle HorizontalAlign="Center" />
<ItemTemplate>
<telerik:RadTextBox ID="rtbFieldTicket" runat="server" EnableEmbeddedSkins="false"
Columns="10">
</telerik:RadTextBox>
</ItemTemplate>
</telerik:GridTemplateColumn>
</Columns>
</MasterTableView>
<ClientSettings EnableRowHoverStyle="true">
<Selecting AllowRowSelect="true" />
</ClientSettings>
</telerik:RadGrid>