Hi!
I tried to export my grid to an excel file, but the dialog if i want to save or open the file is not shown.
Ajax Setting of RadGrid
Grid Declaration
Button Click Event where Export should happen
I tried to catch the OnExcelMLExportRow Created Event but the debugger never falls in the event handler.
Can you please help me to solve this issue?
Regards,
Martin
I tried to export my grid to an excel file, but the dialog if i want to save or open the file is not shown.
Ajax Setting of RadGrid
<telerik:AjaxSetting AjaxControlID="SummaryGrid"> |
<UpdatedControls> |
<telerik:AjaxUpdatedControl ControlID="SummaryGrid"/> |
</UpdatedControls> |
</telerik:AjaxSetting> |
Grid Declaration
<telerik:RadGrid ID = "SummaryGrid" runat="server" AllowSorting="true" AutoGenerateColumns="false" OnExcelMLExportRowCreated="ExportRowCreated" |
Width="900px" Height="280" GridLines="none" OnNeedDataSource="SummaryGridNeedsData" Skin="Telerik"> |
<MasterTableView GroupLoadMode="Client"> |
<Columns> |
<!-- 5 GridGoundColumns !--> |
</Columns> |
<NoRecordsTemplate> |
<div>There are no articles to Display</div> |
</NoRecordsTemplate> |
</MasterTableView> |
<ClientSettings AllowGroupExpandCollapse="true" ReorderColumnsOnClient="true" AllowColumnsReorder="true" AllowDragToGroup="true"> |
<Scrolling AllowScroll="True" UseStaticHeaders="true" /> |
</ClientSettings> |
</telerik:RadGrid> |
Button Click Event where Export should happen
SummaryGrid.ExportSettings.FileName = "Test.xls"; |
SummaryGrid.ExportSettings.ExportOnlyData = true; |
SummaryGrid.ExportSettings.OpenInNewWindow = true; |
SummaryGrid.ExportSettings.IgnorePaging = true; |
SummaryGrid.ExportSettings.Excel.Format = |
Telerik.Web.UI.GridExcelExportFormat.ExcelML; |
SummaryGrid.MasterTableView.ExportToExcel(); |
I tried to catch the OnExcelMLExportRow Created Event but the debugger never falls in the event handler.
Can you please help me to solve this issue?
Regards,
Martin