Really furstrating - Export to excel not working which was working before

[MAULIK]

Hello support,

I have export to excel functionality under a rad grid code snippest attached.
the code was working before and exporting data properly but now I am unable to make export working.


 <telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1" AutoGenerateColumns="false"
                PageSize="10" AllowPaging="true" AllowSorting="true" AllowAutomaticDeletes="true"
                ClientSettings-AllowColumnsReorder="true" OnItemDeleted="RadGrid1_ItemDeleted"
                OnSelectedIndexChanged="RadGrid1_IndexChanged" AllowFilteringByColumn="true"
                OnItemCommand="RadGrid1_ItemCommand" OnItemDataBound="RadGrid1_ItemDataBound"
                EnableAJAX="true" >
                <MasterTableView runat="server" DataSourceID="SqlDataSource1" DataKeyNames="Id" AllowAutomaticDeletes="true"
                    AllowMultiColumnSorting="false">
                    <Columns>
                        <telerik:GridBoundColumn DataField="Id" HeaderText="<%$ Resources:Resource, User.Id.Label %>"
                            Visible="false">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="OrganizationName" HeaderText="OrganizationName"
                            Visible="false">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="OriginalOrganization" HeaderText="OriginalOrganization"
                            Visible="false">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Login" HeaderText="<%$ Resources:Resource, User.Login.Label %>">
                        </telerik:GridBoundColumn>
                        <telerik:GridTemplateColumn HeaderText="Name" AllowFiltering="true" DataField="FirstName"
                            SortExpression="FirstName">
                            <ItemTemplate>
                                <asp:Label ID="lblname" runat="server" Text='<%# string.Format("{0}, {1}", Eval("FirstName"), Eval("LastName")) %>' />
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridBoundColumn DataField="LanguageName" HeaderText="PreferredLan" Visible="false">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="DateOfBirth" Visible="false" HeaderText="DateOfBirth"
                            DataFormatString="{0:d}">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Phone1" HeaderText="Phone1" Visible="false">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Phone2" HeaderText="Phone2" Visible="false">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Email" HeaderText="Email1" Visible="false">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Email2" HeaderText="Email2" Visible="false">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Address1" HeaderText="Address1" Visible="false">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Address2" HeaderText="Address2" Visible="false">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="City" HeaderText="City" Visible="false">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="StateName" HeaderText="<%$ Resources:Resource, User.StateId.Label %>">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="CountryName" HeaderText="CountryName" Visible="false">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Postal" HeaderText="Postal" Visible="false">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="CreationDate" HeaderText="<%$ Resources:Resource, User.CreationDate.Label %>"
                            DataFormatString="{0:d}" SortExpression="CreationDate">
                        </telerik:GridBoundColumn>
                        <telerik:GridTemplateColumn AllowFiltering="false">
                            <ItemTemplate>
                                <asp:ImageButton runat="server" ToolTip="<%$ Resources:Resource, View.Button %>"
                                    ImageUrl="~/App_Themes/Default/Images/gridview.gif" ID="lnkbtn" CommandName="View"
                                    CommandArgument='<%# Eval("Id") %>' Text="<%$Resources:Resource,View %>"></asp:ImageButton>
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="View" Reorderable="false"
                            ConfirmText="<%$Resources:Resource,StrDelete %>" Visible="false">
                        </telerik:GridButtonColumn>
                        <telerik:GridTemplateColumn AllowFiltering="false" Visible="true" HeaderText="Add Rewards">
                            <ItemTemplate>
                                <!-- <asp:ImageButton ID="btnSelect1" ToolTip="Edit" runat="server" ImageUrl="~/App_Themes/Default/Images/gridEdit.gif" CommandName="Select"  /> -->
                                <asp:ImageButton ID="btnAddReward" ToolTip="AddReward" runat="server" ImageUrl="~/App_Themes/Default/Images/gridEdit.gif"
                                    CommandName="AddReward" CommandArgument='<%# Eval("Id") %>' />
                            </ItemTemplate>
                        </telerik:GridTemplateColumn>
                    </Columns>
                    <PagerStyle Position="TopAndBottom" Mode="NextPrevAndNumeric" NextPageText="Next"
                        PrevPageText="Prev"></PagerStyle>
                </MasterTableView>
                <GroupingSettings CaseSensitive="false" />
            </telerik:RadGrid>
 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Ctla1 %>"
                SelectCommandType="StoredProcedure" SelectCommand="Ctla_GetUserList">
                <SelectParameters>
                    <asp:Parameter Name="currentOrgId" Direction="Input" DefaultValue="0" Type="Int32" />
                    <asp:Parameter Name="currentUserId" Direction="Input" DefaultValue="0" Type="Int32" />
                    <asp:Parameter Name="TotalRowCount" Direction="Output" Type="Int32" />
                </SelectParameters>
            </asp:SqlDataSource>

This is ASPx page code.

and the code for aspx.cs page
 protected void btnExportFromDatagridcsv_Click(object sender, ImageClickEventArgs e)
        {
            ConfigureExport();
            RadGrid1.MasterTableView.ExportToCSV();
        }
public void ConfigureExport()
        {
            RadGrid1.ExportSettings.ExportOnlyData = false;
            RadGrid1.ExportSettings.IgnorePaging = true;
            RadGrid1.ExportSettings.OpenInNewWindow = true;
            RadGrid1.ExportSettings.FileName = "UserList";
        }

I also tried several options including
1)   RadGrid1.ExportSettings.ExportOnlyData = true;
2) created a separate page with the simple grid and bind it with a simple datatable and applied export settings and applied export to excel.

[Daniel]

Hello Maulik,

I'm not sure that I understand what happens in your scenario. Actually your code works pretty well on my side so I'm at a loss what could be wrong. Please check the attached project and let me know if I'm missing something.

Best regards,
Daniel
the Telerik team