Remove filter from the Exported XLSX file

[Subhashini]

Hi,

I have a radgrid with the following settings

  <ExportSettings IgnorePaging="true" OpenInNewWindow="true" HideStructureColumns="true">
                                                                    <Excel Format="Xlsx" DefaultCellAlignment="Left" />                                                                    
  </ExportSettings>    

<CommandItemTemplate>
                                                                        <asp:Button ID="btnShowAll" runat="server" Text="Clear Filter" CssClass="fa fa-refresh"
                                                                            AlternateText="Show All" ToolTip="Clear filters" CommandName="InitShowAll" />
                                                                        <asp:Button ID="btnExport" runat="server" Text="Export" CssClass="fa fa-refresh"
                                                                            AlternateText="Export" ToolTip="Export" CommandName="InitExport" />
  </CommandItemTemplate>

The issue is, I couldn't remove the filter row from the exported xlsx file. Even with ExportOnlyData = true the filter row data is visible. 

I also tried filterItem.Visible = false. Sill no luck.

[Eyup]

Hello Subhashini,

Since you've enabled the IgnorePaging property, you can use the following approach to achieve this requirement:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (e.Item is GridFilteringItem && RadGrid1.IsExporting)
    {
        GridFilteringItem filterItem = (GridFilteringItem)e.Item;
        filterItem.Visible = false;
    }
}

That should do the trick.

Regards,
Eyup
Telerik

[Subhashini]

Thank you, Eyup. That fixed the problem. Also, to remove the empty line above the header in xlsx file, which represents the command buttons, i did the same.

If (TypeOf e.Item Is GridCommandItem) Then
            Dim cmdItem As GridCommandItem = CType(e.Item, GridCommandItem)

            If rgTable.IsExporting Then

                cmdItem.Visible = False
            End If
        End If