[转载]C# WinForm导出Excel方法介绍

djk8888

已于 2024-01-11 13:15:42 修改

阅读量2.1k

点赞数

分类专栏： winform 文章标签： c# 开发语言

于 2022-06-22 18:19:54 首次发布

原文链接：https://blog.51cto.com/smilecong/1543859

版权

winform 专栏收录该内容

10 篇文章 1 订阅

订阅专栏

本文介绍了两种使用C# WinForm导出Excel的方法：一种是基于DataGridView控件，另一种是基于DataTable。提供了详细的代码示例，包括创建SaveFileDialog、写入列标题和内容等步骤，帮助开发者实现数据到Excel文件的快速导出。

摘要由CSDN通过智能技术生成

C# WinForm导出Excel方法介绍

https://www.jb51.net/article/44009.htm

C#数据导入/导出Excel文件及winForm导出Execl总结

https://www.jb51.net/article/33671.htm

最后用这个(利用 dataGridView1 导出 excel):

https://blog.51cto.com/smilecong/1543859

用DataGridView控件导出:

        private void btnExcel_Click(object sender, EventArgs e)
        {
            DataGridViewToExcel(this.dataGridView1);
        }

        private void DataGridViewToExcel(DataGridView dgv)
        {
            SaveFileDialog dlg = new SaveFileDialog();
            dlg.Filter = "Execl files (*.xls)|*.xls";
            dlg.CheckFileExists = false;
            dlg.CheckPathExists = false;
            dlg.FilterIndex = 0;
            dlg.RestoreDirectory = true;
            dlg.CreatePrompt = true;
            dlg.Title = "保存为Excel文件";

            if (dlg.ShowDialog() == DialogResult.OK)
            {
                Stream myStream;
                myStream = dlg.OpenFile();
                StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));

                string columnTitle = "";
                try
                {
                    //写入列标题   
                    for (int i = 0; i < dgv.ColumnCount; i++)
                    {
                        if (i > 0)
                        {
                            columnTitle += "\t";
                        }
                        columnTitle += dgv.Columns[i].HeaderText;
                    }
                    sw.WriteLine(columnTitle);
                    //写入列内容   
                    for (int j = 0; j < dgv.Rows.Count; j++)
                    {
                        string columnValue = "";
                        for (int k = 0; k < dgv.Columns.Count; k++)
                        {
                            if (k > 0)
                            {
                                columnValue += "\t";
                            }
                            if (dgv.Rows[j].Cells[k].Value == null)
                                columnValue += "";
                            else
                                columnValue += dgv.Rows[j].Cells[k].Value.ToString().Trim();
                        }
                        sw.WriteLine(columnValue);
                    }
                    sw.Close();
                    myStream.Close();
                }
                catch (Exception e)
                {
                    MessageBox.Show(e.ToString());
                }
                finally
                {
                    sw.Close();
                    myStream.Close();
                }
            }
        }

用DataTable 导出:

 public static void DataTableToExcel(DataTable dt, string fileName = "")
        {
            SaveFileDialog dlg = new SaveFileDialog();
            dlg.Filter = "Execl files (*.xls)|*.xls";
            dlg.CheckFileExists = false;
            dlg.CheckPathExists = false;
            dlg.FilterIndex = 0;
            dlg.RestoreDirectory = true;
            dlg.CreatePrompt = true;
            dlg.Title = "保存为Excel文件";
            dlg.FileName = fileName;

            if (dlg.ShowDialog() == DialogResult.OK)
            {
                Stream myStream;
                myStream = dlg.OpenFile();
                StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.Unicode);//乱码的话,改这里 UTF8 啥的

                string columnTitle = "";
                try
                {
                    //写入列标题   
                    for (int i = 0; i < dt.Columns.Count; i++)
                    {
                        if (i > 0)
                        {
                            columnTitle += "\t";
                        }
                        columnTitle += dt.Columns[i].ColumnName;//ColumnName  Caption
                    }
                    sw.WriteLine(columnTitle);
                    //写入列内容   
                    for (int j = 0; j < dt.Rows.Count; j++)
                    {
                        string columnValue = "";
                        for (int k = 0; k < dt.Columns.Count; k++)
                        {
                            if (k > 0)
                            {
                                columnValue += "\t";
                            }
                            if (dt.Rows[j][k] == null)
                                columnValue += "";
                            else
                                columnValue += dt.Rows[j][k].ToString().Trim();
                        }
                        sw.WriteLine(columnValue);
                    }
                    sw.Close();
                    myStream.Close();
                    MessageBox.Show("导出成功！", "提示");
                }
                catch (Exception e)
                {
                    //MessageBox.Show(e.ToString());
                    //throw e;
                }
                finally
                {
                    sw.Close();
                    myStream.Close();
                }
            }
        }

        //调用
        private void btnExcel_Click(object sender, EventArgs e)
        {
            DataTable dt = GetSth();//从数据库获取数据...
            DataTableToExcel(dt);
        }