b/s导出到excel

  public void ToExcel()
    {

        StringBuilder strData = new StringBuilder();

        strData.Append("<h3 align='right' style='font: 宋体; font-size: 12px;'>导出时间：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "</h3>");

        strData.Append("<table border='1' style='width:100%;border-collapse:collapse;' style='font: 宋体; font-size: 12px;'>" +
        "<tr class='title'>" +
        "<td align ='center' style ='FONT-WEIGHT: bold;font-size: 12px; FONT-FAMILY: 宋体;'>列名1</td>" +
        "<td align ='center' style ='FONT-WEIGHT: bold; font-size: 12px; FONT-FAMILY: 宋体;' >列名2</td>" +
        "<td align ='center' style ='FONT-WEIGHT: bold; font-size: 12px; FONT-FAMILY: 宋体;'>列名3</td>" +
        "<td align ='center' style ='FONT-WEIGHT: bold; font-size: 12px; FONT-FAMILY: 宋体;'>列名4</td>" +
        "</tr>");

     
            strData.Append("<tr>");

            strData.Append("<td align ='left'>东方古典风格的风格</td>");
            strData.Append("<td align ='left'>2</td>");
            strData.Append("<td align ='left'>3</td>");
            strData.Append("<td align ='left'>4</td>");
            strData.Append("</tr>");

            strData.Append("<tr>");

            strData.Append("<td align ='left'>东方古典风格的风格</td>");
            strData.Append("<td align ='left'>2</td>");
            strData.Append("<td align ='left'>3</td>");
            strData.Append("<td align ='left'>4</td>");
            strData.Append("</tr>");

            strData.Append("<tr>");

            strData.Append("<td align ='left'>东方古典风格的风格</td>");
            strData.Append("<td align ='left'>2</td>");
            strData.Append("<td align ='left'>3</td>");
            strData.Append("<td align ='left'>4</td>");
            strData.Append("</tr>");
      
        strData.Append("</table>");

        //HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=s" + DateTime.Today.ToString("d") + ".xls");
        //HttpContext.Current.Response.ContentType = "application/ms-excel";//image/JPEG;text/HTML;image/GIF;vnd.ms-excel/msword  
        //Response.Write("<h3   align='center'>dddd</h3>");
        Page.EnableViewState   =false;  
        //Response.Write(strData.ToString());
        //HttpContext.Current.Response.End();

        byte[] bytesStr = Encoding.GetEncoding("gb2312").GetBytes(strData.ToString());
     
        Response.Clear();
        Response.AddHeader("Content-Disposition",
       "attachment; filename=s" + DateTime.Today.ToString("d") + ".xls");
        //Response.AddHeader("Content-Disposition",
        //       "attachment; filename=" + this.ListBox1.SelectedItem.Text);
        Response.AddHeader("Content-Length", bytesStr.Length.ToString());
        Response.ContentType = "application/octet-stream";
        Response.BinaryWrite(bytesStr);
        Response.End();

 

        //HttpContext.Current.Response.Clear();
        //HttpContext.Current.Response.Buffer = true;
        //HttpContext.Current.Response.Charset = "utf-8";
        //HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("Program", Encoding.UTF8) + " " + DateTime.Today.ToString("d") + ".xls;charset=utf-8");
        //HttpContext.Current.Response.ContentType = "application/ms-excel";
        //HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
        //HttpContext.Current.Response.Write("<h3 align=center>" + "ChinaSunTV Program List" + "</h3>");
        //HttpContext.Current.Response.Write(strData.ToString());

        //HttpContext.Current.Response.Flush();
        //HttpContext.Current.Response.End();

    }