Export Problem from grid

[Giri]

Hi,
    I am exporting datas from radgrid to an excel sheet.But i set the visible of the grid is false.So here there is problem arising to export,the column headers cannot be show only the datas will export.But if i set the visible proerty true for the grid then i the columns also export for me.But only i want to export the grid in invisible mode.
              Codings i am using to export are below..

                RadGrid1.ExportSettings.ExportOnlyData = true;
                RadGrid1.ExportSettings.IgnorePaging = true;
                RadGrid1.ExportSettings.OpenInNewWindow = true;
                RadGrid1.MasterTableView.ExportToExcel();   


Regards,
Giri

[Shinu]

Hi,

Try setting the visbility of the grid before exporting the grid as shown below:

 protected void Button1_Click(object sender, EventArgs e)
        {
            RadGrid1.Visible = true;
            RadGrid1.Rebind();
            RadGrid1.ExportSettings.ExportOnlyData = true;
            RadGrid1.ExportSettings.IgnorePaging = true;
            RadGrid1.ExportSettings.OpenInNewWindow = true;
            RadGrid1.MasterTableView.ExportToExcel();   
        }

Thanks,
Shinu

[Daniel]

Hello Giri,

You should temporary set the Visible property of your RadGrid to true in order to prevent such behavior. The code suggested by Shinu will help you achieve the desired functionality.

Regards,
Daniel
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.