C#datagridview中的数据导入到execl中，包括多维表头

最新推荐文章于 2025-07-07 16:04:51 发布

原创最新推荐文章于 2025-07-07 16:04:51 发布 · 1k 阅读

5 ·

CC 4.0 BY-SA版权

文章标签：

#C# #datagridview #execl

博客提及在C#中添加引用，包括Microsoft.CSharp、Microsoft.Office.Interop.Excel和System.Xml，忽略了与信息技术无关的淘宝小店求关注信息。

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

引用添加Microsoft.CSharp,Microsoft.Office. Interop.Excel,System.Xml

SaveFileDialog sa = new SaveFileDialog();
            sa.Filter = "Excel 97-2003文档(*.xls)|*.xls";
            if (sa.ShowDialog() == DialogResult.OK)
            {
                Thread thread = new Thread(new ThreadStart(delegate
                {
                    Thread.Sleep(2000);
                    ExportExcel(sa.FileName, datagridview1);
                    
                }));
                thread.Start();                          
            }

public void ExportExcel(string saveFileName, DataGridView myDGV)
        {
            Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
            if (xlApp == null)
            {
                MessageBox.Show("无法创建Excel对象，可能你的机器上没有安装Excel！");
                return;
            }

            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   

            Microsoft.Office.Interop.Excel.Range excelRange = worksheet.Range[worksheet.Cells[1, 1], worksheet.Cells[2, 1]];/*需要合并的单元格*/
            Microsoft.Office.Interop.Excel.Range excelRange1 = worksheet.Range[worksheet.Cells[1, 2], worksheet.Cells[2, 2]];
            Microsoft.Office.Interop.Excel.Range excelRange2 = worksheet.Range[worksheet.Cells[1, 3], worksheet.Cells[1, 4]];

            excelRange.Merge(excelRange.MergeCells);/*合并*/
            excelRange1.Merge(excelRange1.MergeCells);
            excelRange2.Merge(excelRange2.MergeCells);
            
            //写入标题  
            for (int i = 0; i < myDGV.ColumnCount; i++)
            {
                if (i < 2)
                {
                    worksheet.Cells[1, i + 1] = myDGV.Columns[i].HeaderText;
                }
                else
                {
                    worksheet.Cells[2, i + 1] = myDGV.Columns[i].HeaderText;
                }
            }
            worksheet.Cells[1, 3] = "性别";
            //写入数据  
            for (int r = 0; r < myDGV.Rows.Count; r++)
            {
                for (int i = 0; i < myDGV.ColumnCount; i++)
                {
                    worksheet.Cells[r + 3, i + 1] = myDGV.Rows[r].Cells[i].Value;
                }
                System.Windows.Forms.Application.DoEvents();
            }
            worksheet.Columns.EntireColumn.AutoFit();//列宽自适应  
            if (saveFileName != "")
            {
                try
                {
                    workbook.Saved = true;
                    workbook.SaveCopyAs(saveFileName);
                }
                catch (Exception ex)
                {
                    MessageBox.Show("导出文件时出错,文件可能正被打开！\n" + ex.Message);
                    return;
                }
            }
            xlApp.Quit();
            GC.Collect();//强行销毁   
        }

 public void ExportExcel(string saveFileName, DataGridView myDGV)
        {
            Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
            if (xlApp == null)
            {
                MessageBox.Show("无法创建Excel对象，可能你的机器上没有安装Excel！");
                return;
            }

            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   

            //Microsoft.Office.Interop.Excel.Range excelRange = worksheet.Range[worksheet.Cells[1, 1], worksheet.Cells[2, 1]];/*需要合并的单元格*/
            //Microsoft.Office.Interop.Excel.Range excelRange1 = worksheet.Range[worksheet.Cells[1, 2], worksheet.Cells[2, 2]];
            //Microsoft.Office.Interop.Excel.Range excelRange2 = worksheet.Range[worksheet.Cells[1, 3], worksheet.Cells[1, 4]];

            //excelRange.Merge(excelRange.MergeCells);/*合并*/
            //excelRange1.Merge(excelRange1.MergeCells);
            //excelRange2.Merge(excelRange2.MergeCells);

            //写入标题  
            int j = 0;
            for (int i = 0; i < myDGV.ColumnCount; i++)
            {
                //if (i < 2)
                //{
                if (myDGV.Columns[i].Visible == false)
                {
                    continue;
                }
                worksheet.Cells[1, j + 1] = myDGV.Columns[i].HeaderText;
                j++;
                //}
                //else
                //{
                //    worksheet.Cells[2, i + 1] = myDGV.Columns[i].HeaderText;
                //}
            }
            //worksheet.Cells[1, 3] = "性别";
            //写入数据  
            for (int r = 0; r < myDGV.Rows.Count; r++)
            {
                int z = 0;
                for (int i = 0; i < myDGV.ColumnCount; i++)
                {
                    
                    if (myDGV.Columns[i].Visible == false)
                    {
                        continue;
                    }
                    worksheet.Cells[r + 2, z + 1] = myDGV.Rows[r].Cells[i].Value;
                    z++;
                }
                System.Windows.Forms.Application.DoEvents();
            }
            worksheet.Columns.EntireColumn.AutoFit();//列宽自适应  
            if (saveFileName != "")
            {
                try
                {
                    workbook.Saved = true;
                    workbook.SaveCopyAs(saveFileName);
                }
                catch (Exception ex)
                {
                    MessageBox.Show("导出文件时出错,文件可能正被打开！\n" + ex.Message);
                    return;
                }
            }
            xlApp.Quit();
            GC.Collect();//强行销毁   
        }