[Solved] Remove columns between Excel & CSV Export

[Kurt Kluth]

I return data to a RadGrid and would like to give the user the option to either export it to a CSV and/or Excel file.  The CSV file would only provide them limited fields that they would need in order to import it into another application.  The Excel version would contain all the columns displayed in the Grid. 

I am currently able to give them the Excel file but is this possible to give them the CSV file using the same grid results only exporting preselected columns?  If so, how would I go about doing this?

Also, is it possible to display the filters (using radFilter) that were applied on the exported file?

[Shinu]

Hi,

I suppose you want to hide the columns before exporting. Here is the sample code.
C#:

protected void Button2_Click(object sender, EventArgs e)
{
        RadGrid1.MasterTableView.GetColumn("UNiqueName").Visible = false;
        RadGrid1.ExportSettings.ExportOnlyData = false;
        RadGrid1.MasterTableView.ExportToExcel();
        RadGrid1.MasterTableView.Rebind();
}

Thanks,
Shinu

[Kurt Kluth]

Shinu,

Thank you for your help as that was extremely helpful.