Drop a column while exporting

[Sabyasachi Dechaudhari]

I have a template column. I dont want to export it.
I tried to do
1. Make the column visible=false before export
grd.Columns[0].Visible = false;

grd.MasterTableView.ExportToExcel();

grd.Columns[0].Visible =

true;

 

2. Add attribute.add to cell and make it visible = false.

e.Row.Cells[0].Attributes.Add(

"visible", "false");

 

3. Remove the cell

e.Row.Cells.RemoveAt(0);

However i was unsucessfull .. can you pls suggest a wasy so that the column is not exported and there is no blank column in the export

 

grd.ExportSettings.IgnorePaging =

true;

 

grd.ExportSettings.OpenInNewWindow =

true;

 

grd.ExportSettings.Excel.Format = Telerik.Web.UI.

GridExcelExportFormat.Html;

 

grd.ExportSettings.ExportOnlyData =

true;

 

[Tsvetina]

Hi Sabyasachi,

I suggest that you find the column which you need to hide by UniqueName and not index:

protected void button1_Click(object sender, EventArgs e)
{
    RadGrid1.MasterTableView.GetColumn("ProductName").Visible = false;
    RadGrid1.MasterTableView.ExportToExcel();
}

Kind regards,
Tsvetina
the Telerik team

[Sabyasachi Dechaudhari]

the problem was i was setting it back to true after firing the command export to excel. I removed the command to convert it back to origin valuw ant it did the trick