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>
...
...
and the button click event:
Thoughts?
Thanks!
...
...
</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!
4 Answers, 1 is accepted
0
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
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
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items
0

William
Top achievements
Rank 1
answered on 29 Aug 2010, 09:27 PM
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
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
0
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
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
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items
0

William
Top achievements
Rank 1
answered on 04 Oct 2010, 07:05 PM
That issue is fixed. Thanks for your help.