程式 . 生活 . D小調

using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Windows;
using System.Windows.Controls;

namespace ExportToCSVByOneCode
{
    public static class DataGridExtendUtility
    {
        /// <summary>
        /// 依照DataGrid內容取得每一列的資料
        /// </summary>
        /// <param name="grid"></param>
        /// <returns></returns>
        public static ICollection<DataGridRow> GetRows(this DataGrid grid)
        {
            List<DataGridRow> rows = new List<DataGridRow>();
            foreach (var rowItem in grid.ItemsSource)
            {
                grid.ScrollIntoView(rowItem, grid.Columns.Last());
                FrameworkElement fel = grid.Columns.Last().GetCellContent(rowItem);
                DataGridRow row = DataGridRow.GetRowContainingElement(fel.Parent as FrameworkElement);
                if (row != null) rows.Add(row);
            }
            return rows;
        }

        public static void ToCSV(this DataGrid grid)
        {

            var title = "";


            foreach (var c in grid.Columns)
            {
                title += "\t" + c.Header.ToString();
            }
            title = title.Remove(0, 1);


            string data = "" + title;
            data += "\r\n";

            foreach (DataGridRow rowItem in grid.GetRows())
            {

                foreach (var c in grid.Columns)
                {
                    var res = "";
                    try
                    {
                        DataGridCell cell = c.GetCellContent(rowItem.DataContext).Parent as DataGridCell;
                        res = (cell.Content as TextBlock).Text;
                    }
                    catch
                    {
                        res = "";
                    }
                    data += res + "\t";
                }
                data += "\r\n";
            }



            SaveFileDialog sfd = new SaveFileDialog()
            {
                DefaultExt = "csv",
                Filter = "CSV Files (*.csv)|*.csv|All files (*.*)|*.*",
                FilterIndex = 1
            };
            if (sfd.ShowDialog() == true)
            {
                using (Stream stream = sfd.OpenFile())
                {
                    using (StreamWriter writer = new StreamWriter(stream, System.Text.UnicodeEncoding.Unicode))
                    {
                        writer.Write(data);
                        writer.Close();
                    }
                    stream.Close();
                }
            }
        }
    }
}

private void btnToCSV_Click(object sender, RoutedEventArgs e)
{
          this.dataGrid1.ToCSV();
}

private void btnToCSV2_Click(object sender, RoutedEventArgs e)
{
    this.dataGrid1.Columns.RemoveAt(0);
    this.dataGrid1.ToCSV();
}