[Solved] how to select some columns to export?

[Jingying]

The export to excel works fine for me.

but if i have 3 columns in my RadGridView, how do i export only the 2 columns?
If i remove the last column, that will be removed from the grid instead.
I only want to remove the last column for export purpose only.

thanks.

[Hristo Deshev]

Hi Jingying,

I recommend that instead of removing your columns, you make them invisible, and then revert that change after the export. Here's a small sample:

var hiddenColumns = new[] { "Age" };
foreach (var columnName in hiddenColumns)
{
    this.RadGridView1.Columns[columnName].IsVisible = false;
}

string content = GetExportedContent();

foreach (var columnName in hiddenColumns)
{
    this.RadGridView1.Columns[columnName].IsVisible = true;
}

All the best,
Hristo Deshev
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Jingying]

That works. Thanks a lot.