public static bool DataSetToExcel(DataSet dataSet, string fileName)

         {

             //建立Excel对象

             var excel = new Microsoft.Office.Interop.Excel.Application();

             var objBook = excel.Workbooks.Open(fileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

             excel.Visible = false;

             var worksheet = (Microsoft.Office.Interop.Excel.Worksheet)objBook.Worksheets["data"];

             DataTable dataTable = DT(dataSet.Tables);

             int rowNumber = dataTable.Rows.Count;//不包括字段名

             int columnNumber = dataTable.Columns.Count;

             int colIndex = ;

             int emptyBlockCount = ;

             //生成字段名称

             foreach (DataColumn col in dataTable.Columns)

             {

                 colIndex++;

                 excel.Cells[, colIndex] = col.ColumnName;

             }

             for (int r = ; r < rowNumber; r++)

             {

                 for (int c = ; c < columnNumber; c++)

                 {

                     worksheet.Cells[r + , c + ] = dataTable.Rows[r][c];

                 }

                 if (string.IsNullOrWhiteSpace(dataTable.Rows[r][].ToString()))

                     emptyBlockCount++;

                 // 如果有10个空行,跳过

                 if (emptyBlockCount > )

                     break;

             }

             objBook.Save();

             objBook.Close();

             excel.Quit();

             return true;

         }

         [DllImport("user32.dll", CharSet = CharSet.Auto, SetLastError = true)]

         static extern int GetWindowThreadProcessId(IntPtr hWnd, out int lpdwProcessId);

             int lpdwProcessId;

             GetWindowThreadProcessId(new IntPtr(excel.Hwnd), out lpdwProcessId);

             System.Diagnostics.Process.GetProcessById(lpdwProcessId).Kill();