自定义位置导出Excel表格：实现文件名编码与样式控制

  protected void Button1_Click(object sender, EventArgs e)
    {
         System.Web.HttpContext curContext = System.Web.HttpContext.Current;
        if (dt != null)
        {
           
       
        string filename = "档案全宗";
        string name1 = filename;
       filename = HttpUtility.UrlEncode(filename, System.Text.Encoding.UTF8);
      

        HttpResponse resp = System.Web.HttpContext.Current.Response;
        resp.Charset = "utf-8";
        resp.Clear();
        resp.AppendHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
        resp.ContentEncoding = System.Text.Encoding.UTF8;

        resp.ContentType = "application/ms-excel";
        string style ="<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=utf-8\"/>"+ "<style> .table{ font: 9pt Tahoma, Verdana; color: #000000; text-align:center;  background-color:#8ECBE8;  }.table td{text-align:center;height:21px;background-color:#EFF6FF;}.table th{ font: 9pt Tahoma, Verdana; color: #000000; font-weight: bold; background-color: #8ECBEA; height:25px;  text-align:center; padding-left:10px;}</style>";
        resp.Write(style);
        //resp.Write(ExportTable(list));
        resp.Write("<table class='table'><tr><th>" +"文件标题"+ "</th><th>" + "档案类别" + "</th><th>" +"发文日期" + "</th><th>" +"文件链接" + "</th><th>" +"备注" + "</th></tr>");
        //VideoList = (List<subShiyongModel>)Session["dbVideoList"];
        for(int i=0;i<dt.Rows.Count;i++)
        {
            resp.Write("<tr><td>" + dt.Rows[i]["FileName"]+ "</td>");
            resp.Write("<td>" +dt.Rows[i]["type"]+ "</td>");
            resp.Write("<td>" + dt.Rows[i]["fromtime"].ToString()+ "</td>");
            resp.Write("<td>" + dt.Rows[i]["url"]+ "</td>");