WPF导出dataGrid数据为EXCEL

string fileName="";
Microsoft.Win32.SaveFileDialog dlg = new Microsoft.Win32.SaveFileDialog();
dlg.DefaultExt = “.xls”; // Default file extension
dlg.Filter = “Excel 工作簿|*.xls”; // Filter files by extension
// Show save file dialog box
Nullable resultDlg = dlg.ShowDialog();
// Process save file dialog box results
if (resultDlg == true)
{
// Save document
fileName = dlg.FileName;

}
//将DataGrid中的数据导入到excel文件中
dataGrid.SelectAllCells();
dataGrid.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader;
ApplicationCommands.Copy.Execute(null, dataGrid);
//String resultat = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue);
String result = (string)Clipboard.GetData(DataFormats.UnicodeText);
dataGrid.UnselectAllCells();
//string textToAdd = “Example text in file”;
FileStream fs = new FileStream(fileName, FileMode.Create);
StreamWriter file1 = new StreamWriter(fs, Encoding.Default);
//file1.Write(textToAdd);
//System.IO.StreamWriter file1 = new System.IO.StreamWriter(@“D:\Users\test.csv”,Encoding.UTF8);
file1.WriteLine(result.Replace(’,’, ’ '));
file1.Close();