Remove Row on Export

[Jerry]

How do I remove rows on Biff Export?  I want them to be visible in the app but removed when exported if a particular column has a null value.

[Doncho]

Hi Jerry,

You can set the Visible property of certain GridDataItems to false when the RadGrid is being rendered for exporting, see Hiding Columns / Rows

For example, in the PreRender event of the grid,  check if the RadGrid is being exported, and loop through its items to disable the visibility of the desired rows:

protected void RadGrid1_PreRender(object sender, EventArgs e)
{
    if (RadGrid1.IsExporting)
    {
        var dataItems = RadGrid1.Items;
        foreach (GridDataItem item in dataItems)
        {
            //opt1. check for the text in a cell
            //if (string.IsNullOrEmpty(item["ShipName"].Text))
                
            //opt2. get a key value
            if (item.GetDataKeyValue("OrderID").ToString() == "6")
            {
                item.Visible = false;
            }
        }
    }
}

I hope this will help. Please let me know if you have further questions.

Kind regards,
Doncho
Progress Telerik