C#datagridview中的資料導入到execl中，包括多元表頭

引用添加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();//強行銷毀   
        }
           

淘寶小店：給個關注