Export to Excel updates but no save as..

[William]

I am setting up a radgrid to export the grid to excel via a button click. It is processing the request. Hiding the columns I don't want to be exported and updating the grid with a new view. It does not have a give me the option to save a file.

  <telerik:RadGrid ID="DisplayDataGrid" runat="server" AutoGenerateColumns="False"

        AllowSorting="True" AllowPaging="True" PageSize="6" OnNeedDataSource="Grid_NeedDataSource"

        OnItemCreated="Grid_ItemCreated" Width="100%" GridLines="None" Skin="Hay" ShowStatusBar="true"

        ItemStyle-Font-Size="7pt" AlternatingItemStyle-Font-Size="7pt">

        <ClientSettings EnableRowHoverStyle="true">

            <Scrolling AllowScroll="True" ScrollHeight="230px" UseStaticHeaders="True" />

        </ClientSettings>

        <ExportSettings IgnorePaging="true" OpenInNewWindow="true" FileName="SeismicPetroWeb2D"

            ExportOnlyData="true" Excel-Format="ExcelML" Excel-FileExtension="xls"  />

   <MasterTableView>

                            <Columns>

 <telerik:GridHyperLinkColumn DataTextField="SURVEY" HeaderText="Survey" SortExpression="SURVEY"

                                    UniqueName="SURVEY">

                                    <HeaderStyle Width="85px" />

                                    <ItemStyle Font-Underline="False" ForeColor="Black" Wrap="False" Width="85px" />

                                </telerik:GridHyperLinkColumn>
...
...

    </telerik:GridHyperLinkColumn>

                            </Columns>

                            <PagerStyle AlwaysVisible="True" />

                        </MasterTableView>

    </telerik:RadGrid>

and the button click event:

 Protected Sub ButtonExcel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles ButtonExcel.Click

        DisplayDataGrid.MasterTableView.Columns(0).Visible = False

        DisplayDataGrid.MasterTableView.Columns(1).Visible = False

     

        DisplayDataGrid.MasterTableView.ExportToExcel()

    End Sub

Thoughts?

Thanks!

[Daniel]

Hello William,

Can you please provide some more information? Do you clear the Reponse headers? Do you see a file dialog popup after you press the export button? If this is so, can you attach a screenshot?

I would also appreciate it if you post some code so that I can examine your approach.

Regards,
Daniel
the Telerik team

[William]

Thanks for the response....


Clear response headers? No file dialog box. It thanks for a few seconds and they reloads the radgrid. It is different format styles and fairly plain.

I posted some code previously, what else would you like to see. It is a massive site with this control used heavily.

Thanks,
RB Bruce

[Daniel]

Hello William,

Judging by the provided information, I suppose that the control that initiates the export is ajaxified. If this is so, please take a look at the link below:
Export from ajaxified grid

Regards,
Daniel
the Telerik team

[William]

That issue is fixed. Thanks for your help.