Exporting without BOM

[Brendan Casey]

Hello -

I have a RadGrid that I am using to present a custom reporting solution for our clients (they choose columns, column order, format, etc. then results are displayed in a RadGrid).

Everything is working great, except that when someone wants to save the file as a CSV, a "byte order marker" (BOM) appears at the beginning of the file.  This marker does not appear in the ExportOutput returned from GridExportingArgs that is fired in the OnGridExporting event.  The BOM is causing our customers to have to edit the file before they can run it through their automated systems.

My question is: How can I prevent the BOM from being saved into the CSV file?  Is this possible?

Thanks in advance,
-Brendan

[Daniel]

Hello Brendan,

You can remove the BOM marker 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();
    }
}

I hope this helps.

Regards,
Daniel
the Telerik team

[Brendan Casey]

Daniel -

This worked perfectly.  Thanks!

-Brendan