New to Telerik UI for ASP.NET AJAX? Download free 30-day trial

How to exclude from Excel export DetailItemTemplate rows and remove the empty rows


Product RadGrid for ASP.NET AJAX


I'd like to export data from a grid, but the grid has a DetailItemTemplate and I'm not able to exclude it from the export. The problem is that the Excel file contains alternating empty rows.


The solution is to hide the DetailTemplateItemDataCell and their parent items:

private void GridPreRender(object sender, EventArgs e)
    if (RadGrid1.IsExporting)
        var dataItems = RadGrid1.Items;
        foreach (GridDataItem item in dataItems) 
            item.DetailTemplateItemDataCell.Visible = false;
            item.DetailTemplateItemDataCell.Parent.Visible = false;
Private Sub GridPreRender(ByVal sender As Object, ByVal e As EventArgs)
    If RadGrid1.IsExporting Then
        Dim dataItems = RadGrid1.Items

        For Each item As GridDataItem In dataItems
            item.DetailTemplateItemDataCell.Visible = False
            item.DetailTemplateItemDataCell.Parent.Visible = False

    End If
End Sub

The extra lines could also have something to do with settings like:

RadGrid1.ClientSettings.Scrolling.AllowScroll = false; RadGrid1.ClientSettings.Scrolling.UseStaticHeaders = false;

In this article