[Solved] Export hidden GridBoundColumns

[Derek]

Hey there,

I have several GridBoundColumns that are set to hidden.  They only display in the edit form view, but I would like them to show up when I export to Excel, PDF and Word.  I've tried the following, but I'm not even sure if it's the right approach:

foreach (GridColumn gc in mlRadGrid.MasterTableView.Columns)
{
     gc.Visible = true;
}

Any help would be much appreciated!

-Derek

[Shinu]

Hi Derek,

Try the following approach to export hidden columns.

CS:

 protected void Button1_Click(object sender, EventArgs e)
    {
        RadGrid1.MasterTableView.GetColumn("ProductName").Visible = true;
        RadGrid1.MasterTableView.Rebind();
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.MasterTableView.ExportToWord();
    }

Thanks
Shinu.