C#怎么将DataGridView中的数据保存到CSV和Excel中

这篇文章主要介绍“C#怎么将DataGridView中的数据保存到CSV和Excel中”，在日常操作中，相信很多人在C#怎么将DataGridView中的数据保存到CSV和Excel中问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”C#怎么将DataGridView中的数据保存到CSV和Excel中”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

一、保存到CSV

        public static bool dataGridViewToCSV(DataGridView dataGridView)        {            if (dataGridView.Rows.Count == 0)            {                MessageBox.Show("没有数据可导出!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);                return false;            }            SaveFileDialog saveFileDialog = new SaveFileDialog();            saveFileDialog.Filter = "CSV files (*.csv)|*.csv";            saveFileDialog.FilterIndex = 0;            saveFileDialog.RestoreDirectory = true;            saveFileDialog.CreatePrompt = true;            saveFileDialog.FileName = null;            saveFileDialog.Title = "保存";            if (saveFileDialog.ShowDialog() == DialogResult.OK)            {                Stream stream = saveFileDialog.OpenFile();                StreamWriter sw = new StreamWriter(stream, System.Text.Encoding.GetEncoding(-0));                string strLine = "";                try                {                    //表头                    for (int i = 0; i < dataGridView.ColumnCount; i++)                    {                        if (i > 0)                            strLine += ",";                        strLine += dataGridView.Columns[i].HeaderText;                    }                    strLine.Remove(strLine.Length - 1);                    sw.WriteLine(strLine);                    strLine = "";                    //表的内容                    for (int j = 0; j < dataGridView.Rows.Count; j++)                    {                        strLine = "";                        int colCount = dataGridView.Columns.Count;                        for (int k = 0; k < colCount; k++)                        {                            if (k > 0 && k < colCount)                                strLine += ",";                            if (dataGridView.Rows[j].Cells[k].Value == null)                                strLine += "";                            else                            {                                string cell = dataGridView.Rows[j].Cells[k].Value.ToString().Trim();                                //防止里面含有特殊符号                                cell = cell.Replace("\"", "\"\"");                                 //cell = "\"" + cell + "\""; //每个元素值用引号包括                                strLine += cell;                            }                        }                        sw.WriteLine(strLine);                    }                    sw.Close();                    stream.Close();                    MessageBox.Show("数据被导出到：" + saveFileDialog.FileName.ToString(), "导出完毕", MessageBoxButtons.OK, MessageBoxIcon.Information);                }                catch (Exception ex)                {                    MessageBox.Show(ex.Message, "导出错误", MessageBoxButtons.OK, MessageBoxIcon.Information);                    return false;                }            }            return true;        }

二、保存到Excel

        public static bool dataGridViewToExcel(DataGridView dataGridView)        {            if (dataGridView.Rows.Count == 0)            {                MessageBox.Show("没有数据可导出!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);                return false;            }            string fileName = "";            string saveFileName = "";            SaveFileDialog saveDialog = new SaveFileDialog();            saveDialog.DefaultExt = "xlsx";            saveDialog.Filter = "Excel文件|*.xlsx";            saveDialog.FileName = fileName;            saveDialog.ShowDialog();            saveFileName = saveDialog.FileName;            if (saveFileName.IndexOf(":") < 0)                return false; //被点了取消            Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();            if (xlApp == null)            {                MessageBox.Show("无法创建Excel对象，您的电脑可能未安装Excel");                return false;            }            Microsoft.Office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks;            Microsoft.Office.Interop.Excel.Workbook workbook =                        workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);            Microsoft.Office.Interop.Excel.Worksheet worksheet =                        (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];//取得sheet1                                                                                          //写入标题                         for (int i = 0; i < dataGridView.ColumnCount; i++)            { worksheet.Cells[1, i + 1] = dataGridView.Columns[i].HeaderText; }            //写入数值            for (int r = 0; r < dataGridView.Rows.Count; r++)            {                for (int i = 0; i < dataGridView.ColumnCount; i++)                {                    worksheet.Cells[r + 2, i + 1] = dataGridView.Rows[r].Cells[i].Value;                }                System.Windows.Forms.Application.DoEvents();            }            worksheet.Columns.EntireColumn.AutoFit();//列宽自适应            MessageBox.Show(fileName + "资料保存成功", "提示", MessageBoxButtons.OK);            if (saveFileName != "")            {                try                {                    workbook.Saved = true;                    workbook.SaveCopyAs(saveFileName);  //fileSaved = true;                                 }                catch (Exception ex)                {//fileSaved = false;                                          MessageBox.Show("导出文件时出错,文件可能正被打开！\n" + ex.Message);                }            }            xlApp.Quit();            Kill(xlApp);            GC.Collect();//强行销毁                  return true;        }

到此，关于“C#怎么将DataGridView中的数据保存到CSV和Excel中”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注编程网网站，小编会继续努力为大家带来更多实用的文章！