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

GridExcelExportFormat.Html Footer

0 Answers 52 Views
Grid
This is a migrated thread and some comments may be shown as answers.
arnaud
Top achievements
Rank 1
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

No answers yet. Maybe you can help?

Tags
Grid
Asked by
arnaud
Top achievements
Rank 1
Share this question
or