This is a migrated thread and some comments may be shown as answers.

GridExcelExportFormat.Html Footer

0 Answers 120 Views

Grid

This is a migrated thread and some comments may be shown as answers.

arnaud asked on 23 Feb 2017, 11:33 PM

Hi,

Using Radgrid with grouping features (ShowFooter="True" + ShowGroupFooter="true") I'm unable to export to excel the footer (GroupFooters export fine).

I'm using GridExcelExportFormat.Html. The Footer data is a column aggregate sum. Using Telerik 2016, 1, 225, 45.

Protected Sub RadGrid1_ItemCommand(ByVal source As Object, ByVal e As GridCommandEventArgs) Handles RadGrid1.ItemCommand

If e.CommandName = Telerik.Web.UI.RadGrid.ExportToExcelCommandName Then

            RadGrid1.ExportSettings.Excel.Format = GridExcelExportFormat.Html
            RadGrid1.ExportSettings.SuppressColumnDataFormatStrings = True
            RadGrid1.ExportSettings.HideStructureColumns = True
            RadGrid1.MasterTableView.GroupsDefaultExpanded = True
            RadGrid1.ExportSettings.IgnorePaging = True
            RadGrid1.ExportSettings.ExportOnlyData = True
            RadGrid1.ExportSettings.OpenInNewWindow = True
            RadGrid1.MasterTableView.ExportToExcel()
End If

Thanks

Arnaud

GridExcelExportFormat.Html Footer

No answers yet. Maybe you can help?