Converting String Column into Date format while Exporting to CSV

[Sachin Agrawal]

Dear Telerik Team,

We are facing an issue while exporting grid data to CSV. Attached are snapshot of our issue. We have two columns for '# of FTEs' and '# of 'Freelancers' which contains values like 1-5, 5-10 and so on. This is shown in the attached file Grid.JPG.
But while expoting these data to CSV, they are converting to date format. It is showing in the attached file Excel.JPG.
Both of these column are having string datatype.

Please suggest solution for this issue.

We look forward to hearing.

Thanks,
Tarika Team

[Daniel]

Hi,

Microsoft Excel parses the cell values automatically depending on the local settings. For example the string 19/05 might change to 19.May automatically. The only workaround would be to insert a sign of equality (=) before the relevant string. For example: "012" should be modified as ="012".
CSV export help topic

Regards,
Daniel
the Telerik team

[Jes]

How can this be done programmatically?  I'm using an older version so I don't have the GridExporting event that seems to be used to do this.  Is there another way?

[Daniel]

Hello Jes,

You could try to insert the equality sign on ItemDataBound event as shown below:

bool isExport = false;
protected void Button1_Click(object sender, EventArgs e)
{
    isExport = true;
    RadGrid1.MasterTableView.ExportToCSV();
}
protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (e.Item is GridDataItem && isExport)
    {
          .... //add = here
    }
}

Let me know whether this helps.

Best regards,
Daniel
the Telerik team