Radgrid export after filtering

[nader]

i export radgrid to excel sheet , sometimes i make filter then export as it should export the filtered data not all the data........the code is :

            radGrid.MasterTableView.AllowPaging = false;
            radGrid.MasterTableView.AllowFilteringByColumn = false;

            radGrid.Rebind();

            radGrid.ExportSettings.FileName = "Logs Sheet_" + DateTime.Now.ToShortDateString();
            radGrid.MasterTableView.ExportToExcel();

line 2 which disable allowfilter is used to hide filter button and text in the same time it export all the data not the filtered and this is the problem .i tried to hide button but there no fuction to hide text..................

[Shinu]

Hello Nader,

You can try the following code to hide the filter row but export the filtered data.

C#:

protected void radGrid_ItemCommand(object source, GridCommandEventArgs e)
    {
        if (e.CommandName == RadGrid.ExportToExcelCommandName)
        {
            foreach (GridFilteringItem filter in radGrid.MasterTableView.GetItems(GridItemType.FilteringItem))
            {
                filter.Visible = false;
            }
            radGrid.MasterTableView.ExportToExcel();
        }
    }

-Shinu.

[Daniel]

Hello Nader,

You can also try the following approach:

radGrid.ExportSettings.IgnorePaging = true;
radGrid.ExportSettings.ExportOnlyData = true;
radGrid.ExportSettings.FileName = "Logs Sheet_" + DateTime.Now.ToShortDateString();
radGrid.MasterTableView.ExportToExcel();

Best regards,
Daniel
the Telerik team

[nader]

thanx shinu for ur help.it worked with this snippet of code :):)