Grid Export to excel + Filters

[Karthik]

Hi,
 I am trying to export the grid by using the default telerik functionality which has the inline filters,
whenever i am trying to export to excel or word , the filters are shown up in the exported file even if the filtering has not been done ,

if (e.CommandName == RadGrid.ExportToExcelCommandName)

        {

            foreach (GridFilteringItem filter in radGrid.MasterTableView.GetItems(GridItemType.FilteringItem))

            {

                filter.Visible = false;

            }

            radGrid.MasterTableView.ExportToExcel();

        }

Even after using this part of code in the ItemCommand its not working, as the Needdatasource event is triggered after the ItemCommand the grid is rebinded  to loose all its settings.
Could you provide me help regarding this issue asap.

-Karthik

[Princy]

Hello Karthik,

Try the following code to achieve your scenario.
C#:

protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
 if (e.CommandName == RadGrid.ExportToExcelCommandName)
 {
    RadGrid1.AllowFilteringByColumn = false;
 }
 RadGrid1.MasterTableView.ExportToExcel();
}

Thanks,
Princy.