how to export from datagrid to excel

See more:

C#

WPF

Hi all,

I have a datagrid with DataGridTemplateColumns. I want to export the datagrid to excel file.

I got a method works great for the exporting except it doesn't work for the TemplateColumns.

I attached my method here.

private void ExportToExcel()
{
    gridTestScript.SelectAllCells();
    gridTestScript.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader;
    ApplicationCommands.Copy.Execute(null, gridTestScript);
    String resultat = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue);
    String result = (string)Clipboard.GetData(DataFormats.Text);
    gridTestScript.UnselectAllCells();
    System.IO.StreamWriter file = new System.IO.StreamWriter(@"C:\Intel\test.xls");
    file.WriteLine(result.Replace(',', ' '));
    file.Close();

    MessageBox.Show(" Exporting DataGrid data to Excel file created");
}

Any help would be really appreciated

Thanks