DataSet数据集存入指定路径的Excel文件

如题，此方法将DataSet的数据存入到同一excel的同一个sheet中，不同的table之间用一个空行隔开。

        /// <summary>
        /// 将DataSet的数据存到指定路径的Excel文件的同一个sheet中，不同的table中间空一行
        /// </summary>
        /// <param name="dsExport">DataSet</param>
        /// <param name="strFileName">Excel文件路径</param>
        public static void DataTable2Excel(DataSet dsExport, string strFileName)
        {
            // Need an Excel App to save document. If Excel is not installed on the user computer, there will be an error message.
            Excel.Application myExcelApp = new Excel.Application();
            if (myExcelApp == null)
            {
                MessageBox.Show("ERROR: EXCEL couldn't be started!");
                System.Windows.Forms.Application.Exit();
            }

            // Let the App create a workbook and a worksheet in the workbook

            Excel.Workbook myWorkbook = (Excel.Workbook)myExcelApp.Workbooks.Add(Type.Missing);
            Excel.Style styHeader; styHeader = myWorkbook.Styles.Add("STYLE_HEADER", Type.Missing);
            Excel.Style styText;

            // styText = myWorkbook.Styles["STYLE_TEXT"];
            styText = myWorkbook.Styles.Add("STYLE_TEXT", Type.Missing);

            //A new workbook contains 3 sheets by default, we need to clear all these blank sheet after adding a new one       
            while (myWorkbook.Sheets.Count > 1)
            {
                ((Excel.Worksheet)myWorkbook.Worksheets[1]).Delete();
            }
       
            Excel.Worksheet myWorksheet = (Excel.Worksheet)myWorkbook.Worksheets.Add(Type.Missing, Type.Missing, 1, Type.Missing);                 
            ((Excel.Worksheet)myWorkbook.Worksheets[1]).Name = "sheet1";

            // iHeaderOffset = 0 means NOT include the column names in the Excel worksheet
            // iHeaderOffset = 1 means include the column names as the first line in the Excel worksheet
            int iHeaderOffset = 0;

            iHeaderOffset = 1;
            DataTable dt;
            int intRows = 0;
            for (int m = 0; m < dsExport.Tables.Count; m++)
            {
                dt = dsExport.Tables[m];

                // Make the column names in DB the HEADER of the worksheet
                for (int j = 0; j < dt.Columns.Count; j++)
                {
                    Excel.Range rng1 = (Excel.Range)myWorksheet.Cells[1 + intRows + m, j + 1];
                    rng1.Style = "STYLE_HEADER";
                    myWorksheet.Cells[1 + intRows + m, j + 1] = dt.Columns[j].ColumnName;
                }
                intRows++;

                #region styHeader
                styHeader.Font.Name = "Arial";
                styHeader.Font.Bold = true;
                styHeader.Font.Size = 10;
                styHeader.Font.Color = ColorTranslator.ToOle(Color.White);
                styHeader.Interior.Color = ColorTranslator.ToOle(Color.DarkBlue);
                styHeader.Interior.Pattern = Excel.XlPattern.xlPatternSolid;
                Excel.Range rng = myWorksheet.Range[myWorksheet.Cells[1, 1], myWorksheet.Cells[1, dt.Columns.Count]];           
                rng.Style = "STYLE_HEADER";
                #endregion styHeader


                #region styText
                styText.Font.Bold = false;
                styText.Font.Size = 10;
                styText.Font.Color = ColorTranslator.ToOle(Color.Black);
                styText.NumberFormat = "@";        
                #endregion styText

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    for (int j = 0; j < dt.Columns.Count; j++)
                    {
                        Excel.Range rng1 = (Excel.Range)myWorksheet.Cells[intRows + m + iHeaderOffset, j + 1];
                        rng1.Style = "STYLE_TEXT";                    
                        myWorksheet.Cells[intRows + m + iHeaderOffset, j + 1] = dt.Rows[i][j].ToString().Trim();
                    }
                    intRows++;
                }
            }

            // Make the output looks good
            myWorksheet.UsedRange.Columns.AutoFit();

            // Save the XLS file
            myWorkbook.SaveAs(strFileName,         // Filename
                                 Excel.XlFileFormat.xlXMLSpreadsheet,   // FileFormat
                                 Type.Missing,                          // Password
                                 Type.Missing,                          // WriteResPassword,
                                 false,                                 // ReadOnlyRecommended,
                                 false,                                 // CreateBackup,
                                 Excel.XlSaveAsAccessMode.xlNoChange,   // AccessMode,
                                 Type.Missing,                          // ConflictResolution,
                                 Type.Missing,                          // AddToMru,
                                 Type.Missing,                          // TextCodepage,
                                 Type.Missing,                          // TextVisualLayout,
                                 Type.Missing                           // Object Local
                            );


            //Close the XLS file.
            myWorkbook.Close(true, Type.Missing, Type.Missing);
            myExcelApp.Quit();
            System.Runtime.InteropServices.Marshal.ReleaseComObject(myWorksheet);
            System.Runtime.InteropServices.Marshal.ReleaseComObject(myWorkbook);
            System.Runtime.InteropServices.Marshal.ReleaseComObject(myExcelApp);
            myWorksheet = null;
            myWorkbook = null;
            myExcelApp = null;
            GC.Collect();

        }