public void SaveDataGridToEMethod(System.Windows.Controls.DataGrid _dataGrid) { SaveFileDialog _saveFileDialog = new SaveFileDialog(); _saveFileDialog.Filter = "Comma separated values files (*.csv) | *.csv"; if (_saveFileDialog.ShowDialog() == true) { _dataGrid.SelectionMode = System.Windows.Controls.DataGridSelectionMode.Extended; _dataGrid.SelectAllCells(); _dataGrid.ClipboardCopyMode = System.Windows.Controls.DataGridClipboardCopyMode.IncludeHeader; System.Windows.Input.ApplicationCommands.Copy.Execute(null, _dataGrid); String result = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue); _dataGrid.UnselectAllCells(); System.IO.StreamWriter file1 = new System.IO.StreamWriter(_saveFileDialog.FileName, false, Encoding.UTF8); file1.WriteLine(result); file1.Close(); _dataGrid.SelectionMode = System.Windows.Controls.DataGridSelectionMode.Single; MessageBox.Show("Файл сохранен!"); } }
public static void Export(System.Windows.Controls.DataGrid dataGrid) { SaveFileDialog dlg = new SaveFileDialog(); dlg.DefaultExt = ".xls"; dlg.Filter = "Text documents (.xls)|*.xls"; Nullable <bool> r = dlg.ShowDialog(); if (r == true) { dataGrid.SelectAllCells(); dataGrid.ClipboardCopyMode = DataGridClipboardCopyMode.IncludeHeader; ApplicationCommands.Copy.Execute(null, dataGrid); String resultat = (string)Clipboard.GetData(DataFormats.CommaSeparatedValue); String result = (string)Clipboard.GetData(DataFormats.Text); dataGrid.UnselectAllCells(); System.IO.StreamWriter file = new System.IO.StreamWriter(dlg.FileName); file.WriteLine(result.Replace(',', ' ')); file.Close(); } }