datagridview导出excel报表函数

最新推荐文章于 2024-01-24 13:23:46 发布

你叫闹闹

最新推荐文章于 2024-01-24 13:23:46 发布

阅读量516

点赞数

CC 4.0 BY-SA版权

分类专栏： winform基本应用

本文链接：https://blog.youkuaiyun.com/qq_15555767/article/details/52910031

winform基本应用专栏收录该内容

42 篇文章

订阅专栏

本文介绍了一种将DataGridView中的数据导出到Excel的方法。通过使用C#编程语言，该过程包括创建保存对话框以选择文件名及路径，并利用StreamWriter将DataGridView的数据逐行写入Excel文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

public static void ExportDataGridViewToExcel(DataGridView dataGridview1)
        {
            try
            {
                if (dataGridview1.Rows.Count > 0)
                {
                    SaveFileDialog saveFileDialog = new SaveFileDialog();
                    saveFileDialog.Filter = "Execl files (*.xls)|*.xls";
                    // saveFileDialog.Filter = "txt files (*.txt)|*.txt";
                    saveFileDialog.FilterIndex = 0;
                    saveFileDialog.RestoreDirectory = true;
                    saveFileDialog.CreatePrompt = true;
                    saveFileDialog.Title = "导出Excel文件到";
                    DateTime now = DateTime.Now;
                    saveFileDialog.FileName = now.Year.ToString().PadLeft(2) + now.Month.ToString().PadLeft(2, '0') + now.Day.ToString().PadLeft(2, '0') + "-" + now.Hour.ToString().PadLeft(2, '0') + now.Minute.ToString().PadLeft(2, '0') + now.Second.ToString().PadLeft(2, '0');
                    DialogResult Result = saveFileDialog.ShowDialog();
                    if (Result == DialogResult.Cancel) //取消导出操作的处理
                    {
                        return;
                    }
                    StreamWriter sw;
                    Stream myStream;
                    myStream = saveFileDialog.OpenFile();
                    sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312"));
                    string str = "";
                    try
                    {
                        //写标题
                        for (int i = 0; i < dataGridview1.ColumnCount; i++)
                        {
                            if (dataGridview1.Columns[i].Visible)
                            {
                                if (i > 0)
                                {
                                    str += "\t";
                                }
                                str += dataGridview1.Columns[i].HeaderText;
                            }
                        }
                        sw.WriteLine(str);
                        //写内容
                        for (int j = 0; j < dataGridview1.Rows.Count; j++)
                        {
                            string tempStr = "";
                            for (int k = 0; k < dataGridview1.Columns.Count; k++)
                            {
                                if (dataGridview1.Rows[j].Cells[k].Visible)
                                {
                                    if (k > 0)
                                    {
                                        tempStr += "\t";
                                    }
                                    if (dataGridview1.Rows[j].Cells[k].Value != null)
                                    {
                                        tempStr += dataGridview1.Rows[j].Cells[k].Value.ToString();
                                    }
                                    else
                                    {
                                        tempStr += "";
                                    }
                                }
                            }
                            sw.WriteLine(tempStr);
                        }
                    }
                    catch (Exception e)
                    {
                        //MessageBox.Show(e.ToString());
                    }
                    finally
                    {
                        sw.Close();
                        myStream.Close();
                        MessageBox.Show("导出成功！存放路径:" + saveFileDialog.FileName);
                    }
                }
                else
                {
                    //MessageBox.Show("没有数据可供导出！", "警告", MessageBoxButtons.OK);
                    return;
                }
            }
            catch
            {
                MessageBox.Show("导出数据出错，请重新操作！", "提示", MessageBoxButtons.OK);
            }
        }