WPF中DataGrid的数据导出到Excel

最新推荐文章于 2023-11-29 14:27:59 发布

coder i++

最新推荐文章于 2023-11-29 14:27:59 发布

阅读量636

点赞数

分类专栏： C# 文章标签： wpf excel

原文链接：https://blog.csdn.net/wangjunlei/article/details/129300654

版权

C# 专栏收录该内容

138 篇文章 10 订阅

订阅专栏

public static void ZdExportToExcel(System.Windows.Controls.DataGrid dg, string name, MetroWindow frm)
        {
           
            dg.SelectAllCells();
 
            dg.ClipboardCopyMode = System.Windows.Controls.DataGridClipboardCopyMode.IncludeHeader;
 
            ApplicationCommands.Copy.Execute(null, dg);
 
            string result = (string)Clipboard.GetData(DataFormats.Text);
 
            string fileName = AppDomain.CurrentDomain.BaseDirectory+name+ ".xls";
 
            dg.UnselectAllCells();
 
            StreamWriter swr = new StreamWriter(fileName, false, Encoding.GetEncoding("gb2312"));
 
            swr.WriteLine(result.Replace(',', ' '));
 
            swr.Close();
 
 
        }

 public static void ExportToExcel(System.Windows.Controls.DataGrid dg, string name, MetroWindow frm)
        {
            dg.SelectAllCells();
 
            dg.ClipboardCopyMode = System.Windows.Controls.DataGridClipboardCopyMode.IncludeHeader;
 
            ApplicationCommands.Copy.Execute(null, dg);
 
            string result = (string)Clipboard.GetData(DataFormats.Text);
 
            SaveFileDialog sfd = new SaveFileDialog();
 
            sfd.FileName = name;
 
            sfd.Filter = "Excel文件(*.xls)|*.xls|Csc文件(*.csv)|*.csv|所有文件(*.*)|*.*";
 
            if (sfd.ShowDialog() == DialogResult.OK)
            {
                string path = System.IO.Path.GetDirectoryName(sfd.FileName);
 
                dg.UnselectAllCells();
 
                StreamWriter swr = new StreamWriter(sfd.FileName, false, Encoding.GetEncoding("gb2312"));
 
                swr.WriteLine(result.Replace(',', ' '));
 
                swr.Close();
            }
        }