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

如题，将DataTable的数据存入指定路径的Excel文件中，具体方法如下：

        /// <summary>
        /// 将DataTable的数据存到指定路径的Excel文件中
        /// </summary>
        /// <param name="dt">DataTable</param>
        /// <param name="strFileName">文件名</param>
        public static void DataTable2Excel(DataTable dt, 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);
            while (myWorkbook.Sheets.Count > 1)
            {
                ((Excel.Worksheet)myWorkbook.Worksheets[1]).Delete();
            }
            //for (int m = 1; m < 4; m++)
            //{
            Excel.Worksheet myWorksheet = (Excel.Worksheet)myWorkbook.Worksheets.Add(Type.Missing, Type.Missing, 1, Type.Missing);
            //A new workbook contains 3 sheets by default, we need to clear all these blank sheet after adding a new one                 

            ((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;

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


            #region styHeader

            //try
            //{
            //    styHeader = myWorkbook.Styles["STYLE_HEADER"];
            //}
            //catch
            //{
            //    styHeader = myWorkbook.Styles.Add("STYLE_HEADER", Type.Missing);
            //}

            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.Columns.Cells.WrapText = true;
            //rng.Columns.WrapText = true;
            //rng.Cells.Width = 20;
            //rng.ColumnWidth = 12;
            rng.Style = "STYLE_HEADER";

            #endregion styHeader


            #region styText


            //styText.Font.Name = "Arial";
            styText.Font.Bold = false;
            styText.Font.Size = 10;
            styText.Font.Color = ColorTranslator.ToOle(Color.Black);
            styText.NumberFormat = "@";
            //styText.Interior.Color = ColorTranslator.ToOle(Color.White);
            //styText.Interior.Pattern = Excel.XlPattern.xlPatternSolid;
            #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[i + 1 + iHeaderOffset, j + 1];
                    rng1.Style = "STYLE_TEXT";
                    //rng1.Columns.WrapText = true;
                    // rng.Cells.Width = 20;
                    //rng1.ColumnWidth = 12;
                    myWorksheet.Cells[i + 1 + iHeaderOffset, j + 1] = dt.Rows[i][j].ToString().Trim();
                }
            }

            // 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();



        }