Exporting RadGrid to an ASCII CSV file

[Tony]

We need to export the data from our RadGrids to just a plain ASCII CSV file for some customers, but the RadGrid "marks the file content as Unicode" (see http://www.telerik.com/help/aspnet-ajax/grid-csv-export.html).

Is there any way to turn off the Unicode marker and just get a plain ASCII file?

We are using the latest version of the components with source license.

Thanks,

Mark Bentley

[Daniel]

Hello Mark,

You can remove the BOM header this way:

protected void RadGrid1_GridExporting(object source, GridExportingArgs e)
{
    if (e.ExportType == ExportType.Csv)
    {
        Response.ContentType = "application/csv";
        Response.AddHeader("Content-Type", "text/csv");
        Response.BinaryWrite(new ASCIIEncoding().GetBytes(e.ExportOutput));
        Response.End();
    }
}

Let me know if you need further assistance.

Best regards,
Daniel
the Telerik team

[Tony]

Thanks Daniel,

That worked great!