黑马程序员_WinForm导出DataSet到Excel中

“----------ASP.Net+Android+IOS开发、Net培训、期待与您交流！----------”

   /// <summary>        /// 导出DataSet到Excel(如果DataSet中有多个DataTable,则会导出到不同的sheet中,但只生成一个excel文件)        /// </summary>        /// <param name="ds">数据集</param>        /// <param name="fileName">D:\\test.xlsx</param>        static void ExportToExcel(DataSet ds, string fileName)        {            //添加引用-->COM-->Microsoft Excel 12.0 Object Library              //Excel程序            Microsoft.Office.Interop.Excel.Application excelApplication = new Microsoft.Office.Interop.Excel.Application();            excelApplication.DisplayAlerts = false;            //工作薄            Workbook workBook = excelApplication.Workbooks.Add(Missing.Value);           //上一个工作薄            Worksheet lastWorkSheet = (Worksheet)workBook.Worksheets.get_Item(workBook.Worksheets.Count);           //空白工作薄            Worksheet newSheet = null;            int i = 0;            foreach (System.Data.DataTable dt in ds.Tables)            {                newSheet = (Worksheet)workBook.Worksheets.Add(Type.Missing, lastWorkSheet, Type.Missing, Type.Missing);                newSheet.Name = dt.TableName+i.ToString();                i++;                for (int col = 0; col < dt.Columns.Count; col++)                {                    newSheet.Cells[1, col + 1] = dt.Columns[col].ColumnName;                }                for (int row = 0; row < dt.Rows.Count; row++)                {                    for (int col = 0; col < dt.Columns.Count; col++)                    {                        newSheet.Cells[row + 2, col + 1] = (dt.Rows[row][col] == null ? "" : dt.Rows[row][col].ToString());                    }                }            }            try            {                //删除默认的3个sheet                ((Worksheet)workBook.Worksheets.get_Item(1)).Delete();                ((Worksheet)workBook.Worksheets.get_Item(1)).Delete();                ((Worksheet)workBook.Worksheets.get_Item(1)).Delete();                workBook.Close(true, fileName, Missing.Value);                return;            }            catch (Exception e)            {                throw e;            }            finally            {                excelApplication.Quit();            }        }