WPF中DataGrid的数据导出到Excel

最新推荐文章于 2023-10-12 16:18:28 发布

开心の码农

最新推荐文章于 2023-10-12 16:18:28 发布

阅读量778

点赞数 3

分类专栏： C# WPF 文章标签： c# wpf Powered by 金山文档

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

版权

WPF 同时被 2 个专栏收录

6 篇文章 0 订阅

订阅专栏

3 篇文章 0 订阅

订阅专栏

无选择导出路径弹窗：

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();
            }
        }