匯出excel函數代碼C#

   public static void ExportToExcel(DataTable dt, string fileName)
        {
            //在做這些前，將Excl添加到引用中來！！
            Excel.Application excel = new Excel.Application();
            //如果系統是Excl2007，添加的引用會不一樣，代碼如下。
            //Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
            if (excel == null)
            {
              
            }
            else
            {
                Excel.Workbook xlBook = excel.Workbooks.Add(true);
                Excel.Worksheet xlSheet = (Excel.Worksheet)xlBook.Worksheets[1];
                //excel.Application.Workbooks.Add(true);           
                int cols = dt.Columns.Count;
                int rows = dt.Rows.Count;
                //列
                for (int k = 0; k < cols; k++)
                {
                    excel.Cells[1, k + 1] = dt.Columns[k].ColumnName;
                }
                //資料
                for (int i = 0; i < rows - 1; i++)
                {
                    for (int j = 0; j < cols; j++)
                    {
                      
                            excel.Cells[i + 2, j + 1] = dt.Rows[i][j].ToString();
                    }
                }
   
                try
                {
                    xlBook.Saved = true;
                    xlBook.SaveCopyAs(fileName);
                }
                catch
                {
             
                }
          
            }
        }

http://files.cnblogs.com/wangdetian168/Interop.Excel.rar