Asp.net SQLServer导出Excel，速度快，支持自定义表格样式什么的，甚是方便！

//事件入口

 protected void lbtALL_Click(object sender, EventArgs e)
    {
        string content = getExcelContent("全部商户列表", "");
        string css = "";
        string filename = Common.GetGuid() + ".xls";

        ExportExcel.ExportToExcel(filename, content, css); 
    }

 private string getExcelContent(string title,string where)
    {
        StringBuilder sb = new StringBuilder();

        sb.Append("<table borderColor='black' border='1' >");
        sb.Append("     <thead>");
        sb.Append("         <tr><th colSpan='8' bgColor='#ccfefe'>" + title + "</th></tr>");
        sb.Append("         <tr>");
        sb.Append("             <th>编号</th>");
        sb.Append("             <th>类别</th>");
        sb.Append("             <th>企业名称</th>");
        sb.Append("             <th>企业地址</th>");
        sb.Append("             <th>企业法人</th>");
        sb.Append("             <th>证件号码</th>");
        sb.Append("             <th>手机号</th>");
        sb.Append("             <th>固定电话</th>");
        sb.Append("             <th>所属</th>");
        sb.Append("         </tr>");
        sb.Append("     </thead>");
        sb.Append("     <tbody>");
        
        DataTable dt = new dJinYinShangHu().GetCompanyListFromView(where).Tables[0];
        if(dt!=null&&dt.Rows.Count>0)
        {
            foreach(DataRow dr in dt.Rows)
            {
                sb.Append("         <tr>");
                sb.Append("              <td>" + dr["UserName"].ToString() + "</td>");
                sb.Append("              <td>" + dr["type"].ToString() + "</td>");
                sb.Append("              <td>" + dr["CompanyName"].ToString() + "</td>");
                sb.Append("              <td>" + dr["CompanyAddress"].ToString() + "</td>");
                sb.Append("              <td>" + dr["LinkMan"].ToString() + "</td>");
                sb.Append("              <td>'" + dr["CardCode"].ToString() + "</td>");
                sb.Append("              <td>'" + dr["Phone"].ToString() + "</td>");
                sb.Append("              <td>'" + dr["Tel"].ToString() + "</td>");
                sb.Append("              <td>" + dr["BranchName"].ToString() + "</td>");
                sb.Append("         </tr>");
            }
        }
        //sb.Append("<tr class='secondTR'><td></td><td bgcolor='lightskyblue'></td></tr>");
        sb.Append("     </tbody>");
        sb.Append("</table>");
        return sb.ToString();

public class ExportExcel
    {
        /// <summary> 
        /// 以流的形式，可以设置很丰富复杂的样式 
        /// </summary> 
        /// <param name="content">Excel中内容(Table格式)</param> 
        /// <param name="filename">文件名</param> 
        /// <param name="cssText">样式内容</param> 
        public static void ExportToExcel(string filename, string content, string cssText)
        {
            var res = HttpContext.Current.Response;
            content = String.Format("<style type='text/css'>{0}</style>{1}", cssText, content);

            res.Clear();
            res.Buffer = true;
            res.Charset = "UTF-8";
            res.AddHeader("Content-Disposition", "attachment; filename=" + filename);
            res.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
            res.ContentType = "application/ms-excel;charset=UTF-8";
            res.Write(content);
            res.Flush();
            res.End();
        } 
    }