Export radGrid to CSV with headers and maintain field types?

[Ken]

Right now I'm using the default export to CSV which maintains my field types when I open the file in excel, ie, currency stays as currency and percent as percent. What I want to do is export the grid with the headings it has also and still maintain type.

Is this possible with export to CSV?

[Jayesh Goyani]

Hello,

Please set below property and let me know its working or not?

protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
        {
            if (e.CommandName == Telerik.Web.UI.RadGrid.ExportToExcelCommandName ||
                e.CommandName == Telerik.Web.UI.RadGrid.ExportToWordCommandName ||
                e.CommandName == Telerik.Web.UI.RadGrid.ExportToCsvCommandName)
            {
                RadGrid1.ExportSettings.ExportOnlyData = false;
            }
        }

Thanks,
Jayesh Goyani