CSV dump as ANSI instead of UTF8

[John Cruz]

Is there a way to convert the CSV file returned by ExportToCSV to ANSI-based csv file instead of a UTF8-based csv file?

I tried wiring to the Grid Exporting event but thats not working because the encoding is hardwired to the response.binarywrite call which is called after the GridExporting event. Any ideas?

It would be awesome if telerik allows customization for the export encoding to ASCII, ANSI, or UTF8. Maybe a property to set the encoding.

protected void grdTransaction_GridExporting(object sender, GridExportingArgs e)
{
    byte[] byteArray = Encoding.UTF8.GetBytes( e.ExportOutput);
    byte[] asciiArray = Encoding.Convert(Encoding.UTF8, Encoding.Default, byteArray);
    e.ExportOutput = Encoding.ASCII.GetString(asciiArray);
}

[Daniel]

Hello John,

Please try the following approach:

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

Let me know whether this helps.

Regards,
Daniel
the Telerik team