<span style="font-family:KaiTi_GB2312;font-size:18px;"> SaveFileDialog objSFD = new SaveFileDialog() { DefaultExt = "csv", Filter = "CSV Files (*.csv)|*.csv|Excel XML (*.xml)|*.xml|All files (*.*)|*.*", FilterIndex = 1 };
if (objSFD.ShowDialog() == true)
{
string strFormat = objSFD.FileName;
dataGrid1.SelectAllCells();
dataGrid1.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader;
ApplicationCommands.Copy.Execute(null, dataGrid1);
dataGrid1.UnselectAllCells();
string result = (string)System.Windows.Clipboard.GetData(System.Windows.DataFormats.CommaSeparatedValue);
File.AppendAllText(strFormat, result, UnicodeEncoding.UTF8);Clipboard.Clear();//清空粘贴板
MessageBox.Show("导出成功");
}</span>
该方法是通过将datagrid的数据复制到粘贴板上,然后读取粘贴板的内容,将datagrid的内容保存为csv格式,该较其它方法来说简单实用易懂。