分享一个导出Excel的类

直接上源码不解释：

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;


public static class ExportExcel
{
    public static void ExportByDataSet(DataSet ds, string fileName)
    {
        DataTable dtData = ds.Tables[0];

        //删除列，修改列头显示
        //dtData.Columns.Remove("");
        //dtData.Columns[0].ColumnName = "行ID";

        dtData.AcceptChanges();

        System.Web.UI.WebControls.GridView dgExport = null;
        System.Web.HttpContext curContext = System.Web.HttpContext.Current;
        System.IO.StringWriter strWriter = null;
        System.Web.UI.HtmlTextWriter htmlWriter = null;
        System.Web.HttpContext.Current.Response.Clear();
        System.Web.HttpContext.Current.Response.HeaderEncoding = System.Text.Encoding.GetEncoding("utf-8");
        curContext.Response.ContentType = "application/vnd.ms-excel";

        fileName = fileName + ".xls";

        curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(fileName));
        curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;
        System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
        curContext.Response.Charset = "";

        strWriter = new System.IO.StringWriter();
        htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
        dgExport = new System.Web.UI.WebControls.GridView();
        dgExport.DataSource = dtData.DefaultView;
        dgExport.AllowPaging = false;
        dgExport.DataBind();
        dgExport.RenderControl(htmlWriter);
        curContext.Response.Write(strWriter.ToString());
        curContext.Response.End();
    }
   
}

使用实例（static 方法，可以被直接调用）：

//ds是某DataSet对象，而后面是导出的Excel保存名字
ExportExcel.ExportByDataSet(ds, "PDLRFQ-" + DateTime.Now.ToString("yyyyMMdd"));