We are using the ToCSV method on RadGridView to export a grid to excel.
This works fine in most regions, but in germany each record appears in a single cell.
This is because germany uses ";" as the CSV separator by default. The current separator can be found in "CultureInfo.CurrentCulture.TextInfo.ListSeparator"
Is there anyway we can force GridView to use a particular separator?
We are using telerik 2009.2.813.35
<code>
var string = RadGridView1.ToCSV();
WriteStringToFile(string);
</code>
This works fine in most regions, but in germany each record appears in a single cell.
This is because germany uses ";" as the CSV separator by default. The current separator can be found in "CultureInfo.CurrentCulture.TextInfo.ListSeparator"
Is there anyway we can force GridView to use a particular separator?
We are using telerik 2009.2.813.35
<code>
var string = RadGridView1.ToCSV();
WriteStringToFile(string);
</code>